SELECT id FROM (select salary2.*, rownum rnum from (select *

write a query to find 4th max salary

Question Posted / sreeharibabu

Answer Posted / sreeharibabu

SELECT id
FROM (select salary2.*, rownum rnum from
(select * from test ORDER BY id DESC) salary2
where rownum <=4)
WHERE rnum >= 4;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is rename in sql?

975

What is pl sql record in oracle?

1036

Does access use sql?

1045

Explain what is a view?

1060

What is view? Can we update view

1440

What is rename command in sql?

1037

Is sql a dbms?

1015

What is a call statement? Explain with an example.

1011

What is the difference between left outer join and left join?

996

explain normalization concept? : Sql dba

1049

Why do we need databases?

1048

What is database migration?

971

What is transaction control language (tcl)?

1139

What is sql trigger example?

1067

What will you get by the cursor attribute sql%rowcount?

1039