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 are different types of sql?

560

Is join and inner join the same?

537

what are the differences between char and varchar? : Sql dba

524

What do we need to check in database testing?

554

what are the join types in tsql? : Transact sql

572

Is sql similar to python?

535

Why we use pl sql?

527

Define SQL and state the differences between SQL and other conventional programming Languages?

679

What is pl sql and why it is used for?

570

How many types of normalization are there?

487

How do I create an index in word?

540

How do I save the results of sql query in a file?

533

What are the two characteristics of a primary key?

488

what is 'mysqlcheck'? : Sql dba

573

What is the mutating table and constraining table?

556