select rownum as rank,sal from (select rownum,sal from emp order by sal

how to retrieve the top 3 salaries of the table using rownum

Question Posted / muneer ahamed

Answer Posted / muneer ahamed

select rownum as rank,sal from (select rownum,sal from emp
order by sal desc)
where rownum<4

Is This Answer Correct ?

4 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is the use of & in pl sql?

988

What are different joins used in sql?

1010

what is the difference between delete and truncate commands? : Sql dba

997

What is a recursive stored procedure?

1098

How to run sql commands in sql*plus?

1082

Is primary key a clustered index?

914

What does pragma mean?

975

What is anonymous block in sql?

1076

Explain the savepoint statement.

1041

define sql delete statement ? : Sql dba

972

What is sp_helptext?

1005

Which function is used to return remainder in a division operator in sql?

1076

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

954

What are the two types of cursors in pl sql?

1004

What is difference between pl and sql?

994