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

1) Does oracle have any table which contain all the exceptions and it's code internally?

1806

How to create a table index?

1230

How to enter a new row into a table interactively?

1053

How to define and use table alias names in oracle?

993

How many data types are supported?

1140

What is a trigger and what are its types?

1330

What is backup in Oracle?

1079

What is using clause and give example?

1109

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2170

What is the difference between a hot backup and a cold backup in oracle?

1079

Explain what are the different type of segments?

1004

What is a package ? What are the advantages of package ?

1138

How would you best determine why your MVIEW couldnt FAST REFRESH?

1933

Explain the difference between sql and oracle?

1127

Please explain oracle data types with examples?

1132