select * from (select * from emp order by sal desc) where rownum

how to retrieve the top 3 salaries of the table using rownum

Question Posted / manoj tcs

Answer Posted / manoj tcs

select * from (select * from emp order by sal desc)
where rownum < 4;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is sql similar to python?

977

What is a boolean in sql?

983

Can function return multiple values in sql?

1061

Where do we use pl sql?

996

Mention what is the plv (pl/vision) package offers?

1107

What are the types of keys?

996

What is the need of merge statement?

1038

How to run pl sql program in mysql?

1021

What are the most important characteristics of pl/sql?

1160

What are the different tcl commands in sql?

1176

what is table? : Sql dba

1064

What is dbo in sql?

963

How do I find sql profiler?

944

Can cursors be part of a trigger body?

1641

How to create a menu in sqlplus or pl/sql?

1127