how to retrieve the top 2 salaried persons from a database?
- 7 Answers
- 8528 Views
- Orion Laboratories, I also Faced
- E-Mail Answers
Answer Posted / abc
Select salary from (select salary from employees order by
salary desc) where rownum <=2;
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is record data type?
What is cte sql?
What is vector point function?
What is the difference between a database and a relational database?
Is natural join same as inner join?
What is query syntax?
What is the difference between function and procedure in pl/sql?
what is online transaction processing (oltp)? : Sql dba
What is the difference between left outer join and left join?
How to run sql commands in sql*plus?
Is not equal in sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
what happens if you no create privilege in a database? : Sql dba
What are three advantages to using sql?
How to know the last executed procedure?
