select rownum as row_id,salary from (select salary from employees order b

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

Question Posted / sunil panghal

Answer Posted / sunil panghal

select rownum as row_id,salary from (select salary from
employees order by salary) where rownum <6;

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to start your 10g xe server?

965

How to convert characters to times in oracle?

953

How to delete all rows a table in oracle?

1007

How do I use os authentication with weblogic jdriver for oracle and connection pools?

996

How to upsert (update or insert into a table)?

950

How to define a procedure inside another procedure?

960

How to get execution path reports on query statements?

926

What is an oracle user role?

936

How to join two tables in a single query using oracle?

928

Write a syntax for update query in oracle?

967

How to view the tablespaces in the current database?

924

Explain the difference between replace() and translate() functions in oracle?

973

What is tns name?

927

What is the use of oracle?

980

How to create id with auto_increment on oracle?

932