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 does the base_object_type column shows in the user.triggers data dictionary view?

1029

what are the 'mysql' command line arguments? : Sql dba

1120

How do I count rows in sql?

978

how are mysql timestamps seen to a user? : Sql dba

1117

What do you think about pl/sql?

1000

How to raise user-defined exception with custom sqlerrm ?

1115

What are the two types of exceptions in pl/sql?

1023

Can I create table without primary key?

981

What is the default isolation level in sql server? : Transact sql

1010

Why is normalization important?

1005

Can we call dml statement in function?

1024

Why do we use procedures in sql?

1058

How many tables can you join in sql?

942

What is the need of merge statement?

1011

What is data type in database?

969