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

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

Please Help Members By Posting Answers For Below Questions

Can there be more than one function with a similar name in a pl/sql block?

985

what is the difference between char_length and length? : Sql dba

1049

Explain spool.

1186

What is a natural join sql?

983

what are date and time data types? : Sql dba

988

What is sql prepared statement?

989

When can we use the where clause and the having clause?

1020

How many sectors are in a partition?

1076

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2172

how to convert numeric values to character strings? : Sql dba

1110

What is procedure explain with program?

1023

Why is the cursor important?

1046

What is a field in a database?

1066

What is procedure function?

1066

How do you use a while loop in pl sql?

1015