select sal,rank()over (order by sal desc) from emp where rownum

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

Question Posted / moorthy(information dynamic)

Answer Posted / moorthy(information dynamic)

select sal,rank()over (order by sal desc) from emp where
rownum < = 3;

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is cursor. write example of it. What are the attributes of cursor.

743

Does sap use sql?

513

How do I view a procedure in sql?

547

Explian rowid, rownum? What are the psoducolumns we have?

567

how to escape special characters in sql statements? : Sql dba

509

What trigger means?

563

What are some predefined exceptions in pl/sql?

548

How do I find duplicates in two columns?

550

What are local and global variables and their differences?

580

what is the syntax used for partition in tsql? : Transact sql

534

How do you use join?

524

What is the order of sql select?

572

What is left inner join in sql?

517

What is pl sql and why it is used for?

570

How to change the order of columns in Oracle SQL Plus ?

610