Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve the top 2 salaried persons from a database?
- 7 Answers
- 10143 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
Can I learn sql in a week?
How do you add a column to a table?
What is the use of pl/sql table?
Explain the structure of pl/sql in brief.
What is the difference between mdf and ndf files?
Is inner join faster than left join?
what is csv? : Sql dba
How to rename a column in the output of sql query?
what is uncommittable transactions? : Transact sql
What is flag in sql?
How to execute a stored procedure?
How do I find duplicates in sql?
What is not null in sql?
When should I use nosql database?
What is procedure explain with program?
