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

How many databases can sql express handle?

970

What is pl sql block structure?

1018

What are different categories of sql commands?

1117

What does (*) mean in sql?

942

Does view contain data?

1016

How do I count records in sql?

981

what is a trigger in mysql? Define different types of trigger. : Sql dba

1053

What is oracle pl sql developer?

965

What is a dirty read sql?

1111

What is auto increment in sql?

1101

What is a full join sql?

1040

What is the purpose of a sql?

964

What is a relationship and what are they?

1131

What is a schema? How is it useful in sql servers?

1098

Is t sql a programming language?

1050