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 rownum?

987

Is postgresql a server?

1055

What is cross join example?

1013

What is gpt format?

946

Is time a data type in sql?

913

How do I find duplicates in sql?

937

What is the difference between local variables and global variables?

1127

Explain the purpose of %type and %rowtype data types with the example?

997

what is the difference between union and union all? : Sql dba

1024

Can we join two tables without common column?

1012

Is sql scripting language?

1058

What is duration in sql profiler trace?

1085

What is the difference between having clause and where clause?

1067

Is sqlite thread safe?

1057

What is rownum and rowid?

1038