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

Explain the the update statement in sql?

1099

what is datawarehouse? : Sql dba

1064

Why is %isopen always false for an implicit cursor?

1151

How to pipe multiline string to isql?

1049

How many types of literals are available in pl sql?

1166

What is crud diagram?

991

tell me about various levels of constraint. : Sql dba

1072

What do you mean by rowid?

1022

What is lookup table in sql?

1090

What is sql partition function?

1287

What are triggers and its uses?

1094

What is a unique key?

1103

What is native sql query?

1074

Which are the different case manipulation functions in sql?

1075

How do you create an update query?

1019