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
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
What is pl sql in oracle?
what are the differences between binary and varbinary? : Sql dba
How can we debug in PL/SQL?
How is data stored in sql?
Which sorts rows in sql?
What is difference between pl and sql?
What are inbuilt functions in sql?
define sql update statement ? : Sql dba
What do you understand by pl/sql cursors?
explain primary keys and auto increment fields in mysql : sql dba
how to rename an existing column in a table? : Sql dba
What are secondary keys?
what is the difference between clustered and non clustered index in sql? : Sql dba
What are triggers and its uses?