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

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

Question Posted / debbie

Answer Posted / debbie

select * from (select sal 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

What is a record in a database?

1103

Can a foreign key be a duplicate?

967

what is schema? : Sql dba

1113

What do you understand by pl/sql cursors?

1149

What are the different types of constraints?

1282

What is coalesce sql?

1056

What is trigger in pl sql?

1051

How many columns should be in an index?

1016

What has stored procedures in sql and how we can use it?

1129

Which language is used in sql?

1122

What is a crud api?

995

How to look at the current sql*plus system settings?

1216

Why we use stored procedure instead of query?

1048

What is trigger in sql? Explain

1045

What is meant by cursor in sql?

1068