select sal from (select sal from emp order by val desc) where rownum <

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

Question Posted / debanjan rudra

Answer Posted / debanjan rudra

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

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I clear the screen in sql plus?

1087

What is join view in sql?

989

What is data abstraction in sql?

1067

What is an ndf file?

1067

Why left join is used in sql?

1020

What is sql basics?

1083

how would you enter characters as hex numbers? : Sql dba

1038

what is foreign key? : Sql dba

1110

What is normalisation and its types?

1045

Can 2 queries be executed simultaneously in a distributed database system?

1194

How do I save a sql query?

1067

What is file based approach?

1002

Differentiate between pl/sql and sql?

1217

Is it possible to link two groups inside a cross products after the cross products group has been created?

1072

What is relationship? How many types of relationship are there?

1264