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 the difference between rownum pseudo column and row_number() function? : Sql dba

1021

What is view? Can we update view

1353

How to use sql*plus built-in timers?

1097

How do you declare a variable in pl sql?

967

What is string data type in sql?

1055

What are pl/sql cursor exceptions?

1037

Can we group by two columns in sql?

946

What are the string functions in sql?

926

What are the most important ddl statements in sql?

1027

What are the syntax and use of the coalesce function?

1105

How do I copy a table in sql?

931

What is %type in pl sql?

926

What is trigger in sql and its types?

992

How do I save a stored procedure?

951

How does a self join work?

994