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

Answer Posted / swapnareddy

select sal from emp a where 3>(select
count(distinct(sal))from emp b where a.sal<b.sal);

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

718


What is pl sql in oracle?

579


what are the differences between binary and varbinary? : Sql dba

529


How can we debug in PL/SQL?

655


How is data stored in sql?

547






Which sorts rows in sql?

585


What is difference between pl and sql?

528


What are inbuilt functions in sql?

595


define sql update statement ? : Sql dba

570


What do you understand by pl/sql cursors?

546


explain primary keys and auto increment fields in mysql : sql dba

518


how to rename an existing column in a table? : Sql dba

509


What are secondary keys?

557


what is the difference between clustered and non clustered index in sql? : Sql dba

547


What are triggers and its uses?

593