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

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

Question Posted / seetharam

Answer Posted / seetharam

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

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are the types of queries in sql?

1015

how to get a list of all tables in a database? : Sql dba

918

What are local and global variables and their differences?

1045

what is the difference between myisam static and myisam dynamic? : Sql dba

1002

What is procedure and function in sql?

928

How do you know if a relationship is 2nf?

877

Can a procedure in a package be overloaded?

982

What is clustered index sql?

931

What are the types of functions in sql?

966

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

899

What is prepared statement in sql?

993

What has stored procedures in sql and how we can use it?

1014

What is pl sql in dbms?

900

Why do we need cursor in pl sql?

1079

Which sql statement is used to delete data from a database?

896