select salery from (select salery from emp order by salery desc) where ro

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

Question Posted / kishore

Answer Posted / kishore

select salery from (select salery from
emp order by salery desc) where rownum <=5 ;

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

who introduced sql?

1026

Is not equal in sql?

1015

What is clause?

1156

How to look at the current sql*plus system settings?

1152

What are expressions?

1017

How do I debug a stored procedure?

1117

How do you update a table in sql?

993

Is there a 64 bit version of ssms?

961

Write a sql query to get the third highest salary of an employee from employee_table?

1075

how to shut down the server with 'mysqladmin'? : Sql dba

1014

how to analyze tables with 'mysqlcheck'? : Sql dba

1013

What are procedures used for?

986

What is before trigger?

1006

How to pipe multiline string to isql?

1008

What is a data definition language?

1139