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

How do I partition a table in sql?

1209

Why do we need view in sql?

1039

Can pl sql procedure have a return statement?

1072

Explain the purpose of %type and %rowtype data types?

977

How do sql databases work?

1049

What are tuples in sql?

1200

What is pl/sql table? Why is it used?

1095

Explain what is a view?

1118

How do I enable sql encryption?

1073

what are the authentication modes in sql server? : Sql dba

1122

what is the command line end user interface - mysql? : Sql dba

1031

What are different categories of sql commands?

1199

What is audit logout in sql profiler?

1076

What do you understand by pl/sql records?

1062

What is the purpose of a sql?

1044