for example if we take emp table, the query like this... select a.sal fro

write a query to find 4th max salary

Question Posted / raj

Answer Posted / raj

for example if we take emp table, the query like this...
select a.sal from emp a where 4=(select count(distinct(b.sal))from emp b where a.sal<=b.sal)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is the difference between sql and t-sql? : Transact sql

1089

how to check myisam tables for errors? : Sql dba

1321

What are the different types of joins in sql?

1797

What is the use of index in sql?

1017

What is a constraint?

1027

Can you have a foreign key without a primary key?

955

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1074

Can we use views in stored procedure?

1035

What is loop in pl sql?

1040

What are the types of keys?

997

What is the difference between inner join and left join?

990

Can we join more than 2 tables in sql?

1024

What does pl sql stand for?

1119

What is sqlcommand?

1032

what is table? : Sql dba

1068