select rownum, sal from (select * from emp order by sal desc) where rownum

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

Question Posted / k.thrilok kumar

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

Answer Posted / k.thrilok kumar

select rownum, sal from (select * from emp order by sal
desc) where rownum<=3

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is data manipulation language? : Sql dba

943

what is the difference between primary key and unique key? : Sql dba

968

What is compiled query?

952

How many databases can sql express handle?

941

how to add a new column to an existing table in mysql? : Sql dba

1000

What is sql data?

922

What is program debugging?

1127

Can unique keys be null?

850

What is information schema in sql?

1012

What is the difference between instead of trigger and after trigger?

947

How to use sql statements in pl/sql?

1051

Which command is used to call a stored procedure?

949

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3923

What is rowid in sql?

905

What is sql rowcount?

946