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

31 Answers
42757 Views
Oracle, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I restart sql?

1026

Does truncate table reset auto increment?

1050

Who developed sql?

1099

How show all rows in sql?

1057

How to sort the rows in sql.

1122

what are the t string functions available in tsql? : Transact sql

1064

Explain table and field in sql?

1117

Is sql a case sensitive language?

1010

what is innodb? : Sql dba

1172

What is procedure and function in sql?

1045

Define implicit and explicit cursors.

1207

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1088

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2339

Is sql easier than java?

1069

Mention what is the use of function "module procedure" in pl/sql?

1088