select empno, ename, sal from (select * from emp order by sal desc) where

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

Question Posted / vik

31 Answers
41907 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / vik

select empno, ename, sal from (select * from emp order by
sal desc) where rownum < 4

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is sql profiler? : Sql dba

1056

what is error ora-03113: end-of-file on communication channel?

1171

What is a .db file?

992

What is dynamic sql in pl sql?

1042

What is a database event trigger?

1165

What is indexing in sql and its types?

1089

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1019

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1141

Is primary key clustered or nonclustered?

1027

what is 'mysqld'? : Sql dba

979

How can we link a sql database to an existing android app?

1038

Is nosql relational?

947

Can we insert delete data in view?

955

Explain ddl statements in pl/sql?

1013

Why is there a need for sqlcode and sqlerrm variables?

1057