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

What is range partitioning?

976

What is plpgsql language?

1070

What is difference between mysql and postgresql?

1164

how to use regular expression in pattern match conditions? : Sql dba

1044

What is the use of nvl function?

1206

What are the different operators available in sql?

1012

Is left join inner or outer?

1029

Where can I learn sql for free?

1000

What are stuff and replace function?

1091

What is bitemporal narrowing?

1315

Why is %isopen always false for an implicit cursor?

1118

What are different joins used in sql?

1067

what are null values? : Sql dba

964

What is a primary key? Explain

988

what are the authentication modes in sql server? How can it be changed? : Sql dba

1442