how to retrieve the top 2 salaried persons from a database?
Answer Posted / arun
select salary from(select salary from(select distinct salary from employees order by salary desc) where rownum<=2 order by salary) where rownum=1;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is sql prepared statement?
How does an execution block start and end in pl sql?
what is bdb (berkeleydb)? : Sql dba
What are the parameter modes supported by pl/sql?
Are subqueries faster than joins?
What is nvarchar max in sql?
What is the difference between rollback and rollback to statements?
What is sql in java?
What is microsoft t sql?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What does sign mean sql?
What is left inner join in sql?
What is sql rowcount?
What are reports usually used for?
What is a primary key? Explain