Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve the top 2 salaried persons from a database?
- 7 Answers
- 9921 Views
- Orion Laboratories, I also Faced
- E-Mail Answers
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
How is a PL/SQL code compiled?
What is the use of desc in sql?
How do you pronounce sql?
Does a join table need a primary key?
What is the basic form of sql query?
What happens when a trigger is associated to a view?
Does a primary key have to be a number?
what are aggregate and scalar functions? : Sql dba
can a stored procedure call itself or recursive stored procedure? : Sql dba
How to run sql statements through the web interface?
Explain cursor types?
what are set operators in sql? : Sql dba
What is coalesce in sql?
What are sql functions? Describe the different types of sql functions?
What is sql clause?
