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 are the different ways to optimize a sql query?

891

Explain spool.

1114

What are different types of triggers?

1029

What is pragma in pl sql?

1021

Which is faster joins or subqueries?

931

How do you optimize a stored procedure query?

939

How do I quit sql?

900

Why do you partition data?

967

What is the difference between syntax error and runtime error?

1069

What will you get by the cursor attribute sql%notfound?

1014

How do you get column names only for a table (sql server)?

1102

Why is sql better than hql?

921

How to fetch alternate records from a table?

1160

What is database migration?

916

What are sql data types?

953