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

Can we use pl sql in sql server?

739

what is sp_pkeys? : Transact sql

889

How to pronounce postgresql?

759

how to use like conditions? : Sql dba

780

What are pl sql procedures?

695

what is data manipulation language? : Sql dba

700

How do I debug a stored procedure?

811

What is Difference Between Unique and Primary Key Constraints?

825

How do you take the union of two tables in sql?

730

What is the most restrictive isolation level? : Transact sql

768

Explain the commit statement.

848

What is rtm in testing?

756

What is record data type?

677

How do I make sql search faster?

767

What is pl sql package?

795