Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
Answer Posted / ram
select ename,salary from(select ename,salary from emp order by salary desc) where rownumber<6
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sqlerrd?
how can we destroy the cookie? : Sql dba
How to sort the rows in sql.
Does postgresql run on the cloud?
What is a record in pl/sql?
tell us something about heap tables. : Sql dba
How do you clear the screen in sql?
How do I get sql certification?
What is data definition language?
how are mysql timestamps seen to a user? : Sql dba
Do we need to rebuild index after truncate?
Can a view be mutating? If yes, then how?
What is the use of %rowtype?
Mention what are the benefits of pl/sql packages?
What is the use of desc in sql?