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

Explain the commit statement.

1162

Explain spool.

1186

What is primary key sql?

1043

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1073

What is the cause of mutating table error and how can we solve it?

1051

What is the importance of sqlcode and sqlerrm?

1356

Does sql view stored data?

961

what is commit? : Sql dba

1080

What are different sql data types?

1051

Is not null in sql?

1000

what are enums used for in mysql? : Sql dba

1170

what is a field in a database ? : Sql dba

1062

What is the use of index in hive?

1007

What are hotfixes and patches?

949

How bulk collect improves performance?

1010