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

how to convert dates to character strings? : Sql dba

1254

What is difference sql and mysql?

1038

Which one is better sql or oracle?

1015

What are all the common sql functions?

1085

What is numeric function sql?

1108

How do I run sql profiler?

1119

What is partition by in sql?

1132

What is file based approach?

1002

What is an intersect?

1156

Does sql profiler affect performance?

1048

Is mariadb nosql?

1093

what is the difference between where clause and having clause? : Sql dba

1047

How to look at the current sql*plus system settings?

1216

How do you create a unique index?

1094

How to handle bulk data?

1368