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

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

Please Help Members By Posting Answers For Below Questions

What is dml with example?

1156

How many types of primary keys are there?

1082

How to change sql*plus system settings?

1111

What are the types pl/sql code blocks?

1197

What sql database should I use?

1201

Explain the difference between drop and truncate commands in sql?

1113

What is the current version of sql?

1070

How many types of triggers exist in pl/sql?

1137

what are dynamic queries in t-sql? : Transact sql

1070

how to add a new column to an existing table in mysql? : Sql dba

1115

How does rowid help in running a query faster?

1475

What are the disadvantages of file system?

1364

What is record in pl sql?

1140

What is the maximum number of rows in sql table?

1080

Does execute immediate commit?

1291