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 difference between stored function and application function?

1217

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

1161

what is the functionality of the function htmlentities? : Sql dba

972

What is difference between pl and sql?

1073

What is coalesce in sql?

1071

Does normalization improve performance?

1045

Can ddl statements be used in pl/sql?

1152

What is delete command in sql?

1126

Explain normalization and what are the advantages of it?

962

What is procedure function?

1072

What is view explain with example?

940

how can we repair a mysql table? : Sql dba

990

What is function and procedure?

1040

How can you fetch common records from two tables?

1070

what does myisamchk do? : Sql dba

1036