select ename,salary from(select ename,salary from emp order by salary desc)

Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Question Posted / ram

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

Please Help Members By Posting Answers For Below Questions

What is sqlerrd?

968

how can we destroy the cookie? : Sql dba

1011

How to sort the rows in sql.

1075

Does postgresql run on the cloud?

1147

What is a record in pl/sql?

1146

tell us something about heap tables. : Sql dba

1098

How do you clear the screen in sql?

1067

How do I get sql certification?

971

What is data definition language?

1092

how are mysql timestamps seen to a user? : Sql dba

1139

Do we need to rebuild index after truncate?

1035

Can a view be mutating? If yes, then how?

1027

What is the use of %rowtype?

1041

Mention what are the benefits of pl/sql packages?

1081

What is the use of desc in sql?

977