select sal from (SELECT distinct sal FROM emp order by sal desc) where r

how will I find the first 5 highest salaried employees in
each dept in oracle.

Question Posted / uttam

Answer Posted / uttam

select sal from (SELECT distinct sal FROM emp order by sal
desc)
where rownum <6

Is This Answer Correct ?

13 Yes

15 No

Please Help Members By Posting Answers For Below Questions

How to drop a stored function?

1104

Describe varray?

1015

Is oracle the best database?

936

Explain oracle insert into command?

1072

How will you identify oracle database software release?

960

Where are the settings stored for each instance in oracle?

1081

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4130

What are the ways tablespaces can be managed and how do they differ?

2301

Explain a synonym?

991

What are the database administrators utilities available?

994

How to load data through external tables?

1092

How do I connect to oracle database?

1053

Which are the five query types available in oracle?

921

How do I limit the number of rows returned by an oracle query after ordering?

1120

What is the data type of dual table?

944