how to retrieve the top 2 salaried persons from a database?
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
How show all rows in sql?
what is a tablespace? : Sql dba
define join and explain different type of joins? : Sql dba
What is consistency?
Who developed sql?
What is a sql schema used for?
How do you sort in sql?
What is the primary key?
Explain the rollback statement?
How many disk partitions should I have?
What is parallel hint?
What is sql and also describe types of sql statements?
What is dml statement?
What is field delimiter?
What is the difference between rollback and rollback to statements?