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

explain the difference between myisam static and myisam dynamic. : Sql dba

988

What is the difference between a subquery and a join?

1169

What does varchar include?

991

Which are the different character-manipulation functions in sql?

1109

Can we use insert statement in function?

1045

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1179

What are transaction and its controls?

1089

what is rollback? : Sql dba

1178

Is a foreign key always unique?

980

What is a data definition language?

1195

what are the types of subquery? : Sql dba

1155

Is pl sql a scripting language?

1079

Is foreign key mandatory?

1064

Explian rowid, rownum?

1075

How to rename a column in the output of sql query?

1122