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

Which is faster truncate or drop?

563

How can we store rows in PL/SQL using array?

668

What is the difference between instead of trigger and after trigger?

514

Is sql between inclusive?

591

Is postgresql a server?

577

What is the basic form of sql query?

495

Define the select into statement.

576

Differentiate between pl/sql and sql?

619

How many functions are there in sql?

542

What is the purpose of a sql?

531

What is a scalar value in sql?

590

How do I view a sql database?

561

The select into statement is most often used to create backup copies of tables or for archiving records?

561

how to convert dates to character strings? : Sql dba

539

How do I send sql query results to excel?

582