select empname,sal from (select empname,sal from dh1 order by sal desc)

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

Question Posted / dhiman sarkar

Answer Posted / dhiman sarkar

select empname,sal from (select empname,sal from dh1 order
by sal desc)
where rownum < =4
order by sal desc

Is This Answer Correct ?

17 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Is pl sql useful?

997

Is sql dba a good career? : SQL DBA

997

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

1067

differentiate between float and double. : Sql dba

1060

what are the limitations of identity column? : Transact sql

1108

What is latest version of sql?

1052

Explain aggregate functions are available there in sql?

1012

What is data definition language?

1097

Which kind of parameters cannot have a default value in pl sql?

1153

What is replication id?

941

Is record in pl sql?

979

Can triggers stop a dml statement from executing on a table?

1106

Can we insert data into materialized view?

950

How many sql commands are there?

1122

How do I edit a stored procedure?

998