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

a query to select maxmun 3 salaries of employee table

Question Posted / tulasi

Answer Posted / tulasi

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

Is This Answer Correct ?

21 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How to write an inner join with the where clause in oracle?

994

What are transaction isolation levels supported by oracle?

994

What is pragma autonomous transaction in oracle?

990

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2432

Explain constraining triggers.

1043

Are truncate and delete commands same? If so why?

1079

Can we write insert statement in function in oracle?

1026

How to convert a string to a date in oracle database?

1000

Oracle

2319

What is an oracle recycle bin?

930

How to rename a column in an existing table?

972

How to loop through a cursor variable?

1011

What is a database schema in oracle?

1054

How can you use check constraints for self referential integrity?

916

What are the attributes that are found in a cursor?

1011