Select * from emp where emp.salary in (select emp.salary from emp

how to retrieve the top 3 salaries of the table using rownum

Question Posted / ram

Answer Posted / ram

Select * from emp
where emp.salary in (select emp.salary from emp
where (select distict salary
from emp order by desc null last)
where rownum <=3);

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What do you mean by stored procedures?

1015

what is a view? : Sql dba

1101

What are all the common sql functions?

1035

What is sap sql anywhere?

1085

What are the different sql languages?

1042

What is a sql instance vs database?

1120

Explain dml and ddl?

1001

Mention what pl/sql package consists of?

1003

What is pl sql script?

1036

Why is stored procedure faster than query?

964

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7355

What is count * in sql?

1001

Is sql better than excel?

1158

What are the different types of a subquery?

1052

What are aggregate and scalar functions?

1026