select ename ,sal from (select ename,sal from emp order by sal desc) w

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

Question Posted / rameshwar gupta

Answer Posted / rameshwar gupta

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

Is This Answer Correct ?

8 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the function that is used to transfer a pl/sql table log to a database table?

1069

What is a relationship and what are they?

1230

What is rtm in testing?

1175

What found sql?

995

How many types of keys are there in sql?

1088

Mention what is the plv (pl/vision) package offers?

1163

How do you pronounce sql?

1061

what is the difference between undefined value and null value? : Sql dba

1146

how to use myisamchk to check or repair myisam tables? : Sql dba

1018

What is sql partition function?

1292

What is a record in pl/sql?

1217

How delete all records from table in sql?

1014

How can use stored procedures in sql?

1192

what is foreign key? : Sql dba

1110

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

1068