for example if we take emp table: select a.sal from emp a where 4=(selec

write a query to find 4th max salary

Question Posted / raj

Answer Posted / raj

for example if we take emp table:

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 ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can we group by two columns in sql?

988

how to calculate the difference between two dates? : Sql dba

1057

What is sql profiling in oracle?

1057

What is sql indexing?

1008

What are schema-level triggers?

1097

How to change sql*plus system settings?

1050

what is dbms? : Sql dba

989

What is information schema in sql?

1067

What are the syntax and use of the coalesce function?

1196

Explain the difference between triggers and constraints?

967

What are the advantages of normalization?

1075

What is compound trigger?

1032

How do we accept inputs from user during runtime?

1054

What is difference between table and view?

1048

What is sql profiler in oracle?

1087