select * from (select * from emp order by sal desc) where rownum

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

Question Posted / manoj tcs

Answer Posted / manoj tcs

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is stored procedure faster than query?

916

What is sql keyword?

946

How to use transactions efficiently : transact sql

993

Can a select statement fire a trigger?

1099

Which is better trigger or stored procedure?

881

What is nvarchar in sql?

887

What is clustered index sql?

934

How do I run a sql query?

969

Is sql developer case sensitive?

945

Which are the different character-manipulation functions in sql?

990

what is single byte over head in oracle..?

2342

What is the file extension for sql database?

939

Explain character-manipulation functions?

1070

What are the disadvantages of file system?

1165

How to prepare for oracle pl sql certification?

1012