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

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7279

what is the difference between undefined value and null value? : Sql dba

1080

How do I tune a sql query?

961

What is not in sql?

937

How do I view an execution plan in sql?

971

Define join and name different types of joins?

992

what is a database? : Sql dba

1149

How do you modify a table in sql?

1108

How do you break a loop in pl sql?

1034

what is a database transaction? : Sql dba

1155

Is a view faster than a stored procedure?

951

Can you inner join the same table?

982

what is the difference between clustered and non clustered index in sql? : Sql dba

1109

What is multiple columns?

1049

What are different types of statements supported by sql?

1148