select rownum as rank,sal from (select rownum,sal from emp order by sal

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

Question Posted / muneer ahamed

Answer Posted / muneer ahamed

select rownum as rank,sal from (select rownum,sal from emp
order by sal desc)
where rownum<4

Is This Answer Correct ?

4 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Explain what is a database?

1136

Which are the different case manipulation functions in sql?

1077

What are different types of queries in sql?

1178

What is spool?

1111

What is a constraint?

1085

What is data control language?

1034

Why do we use sqlite?

1029

Can a table have no primary key?

1112

Define overloaded procedure?

1133

What is cartesian join in sql?

1196

Which join is like an inner join?

1095

Why do we use joins?

1101

what is uncommittable transactions? : Transact sql

1038

how to select unique records from a table? : Sql dba

1176

How do I run a query in pl sql developer?

1053