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

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

979

How to call a stored function with parameters?

1049

What the is the diff between local index and global index. give some example.

1642

When do I need to use a semicolon vs a slash in oracle sql?

1090

How to sort output in descending order in oracle?

1047

What is an oracle tablespace?

1046

what is a Nested Loop join?

2119

How to create a new table in oracle?

1159

How can you merge two tables in oracle?

1001

What is Trigger in Oracle?

1176

How to check the server version in oracle?

1094

What is the implicit cursor in oracle?

1108

What is user managed backup in Oracle?

1146

How to call a sub procedure?

1099

How to call a stored function in oracle?

1019