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 is the starting oracle error number?

1097

Is a view faster than a stored procedure?

1010

What is set serveroutput on in pl sql?

1359

Difference between global and parameter variables?

2013

Write the command to remove all players named sachin from the players table.

1227

Write a sql query to find the names of employees that begin with ‘a’?

1057

where are cookies actually stored on the hard disk? : Sql dba

1079

Is left join and outer join same?

1115

when is the use of update_statistics command? : Sql dba

1099

What is primary key and foreign key with example?

981

what are the advantages of sql ? : Sql dba

1105

What is dense_rank?

989

What are different types of keys?

1172

What is sql table?

1022

What is pivot query?

1120