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

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

Question Posted / akki julak

Answer Posted / akki julak

select sal from (select rownum,sal from emp order by sal
desc)
where rownum<4;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a common use of group by in sql?

1053

What is information schema in sql?

1078

What is lookup table in sql?

1054

What is a column in a table?

1134

Can sql developer connect to db2?

1058

What is the difference between row level and statement level trigger?

1031

what is acid property in database? : Sql dba

1038

Define commit, rollback and savepoint?

1038

what is a record in a database ? : Sql dba

1069

What is sql performance tuning?

929

Explain scalar functions in sql?

1076

What is union?

1178

What are sql*plus environment variables?

1101

What if we write return in procedure?

1438

How to run sql statements with oracle sql developer?

1081