Latest Answer: The query isselect max(sal) from emp where sal < (select max(sal) from emp where rownum ...
Latest Answer: We can do remove the duplicate records using the below single queryDelete from table1 where rowid not in (select max(rowid) from table1 group by dup_col) ...
Latest Answer: count(1) is faster than count(*) ...
There are 2 tables, Employee and Department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their corresponding departments, if the department is assigned otherwise employee names and null value in the place department name. What is the query?
View page << Previous 3 4 5 6 [7]
Go Top
