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

what is the functionality of the function htmlentities? : Sql dba

960

Can we use update in sql function?

1057

Where is all the data on the internet stored?

1009

Why schema is used in sql?

1047

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1222

What's the difference between a primary key and a clustered index?

986

What is indexing in sql and its types?

1078

What is a composite primary key?

1093

How do I count duplicates in sql?

1105

How do I find duplicates in a single column in sql?

1020

How can I see all tables in sql?

1073

Which join condition can be specified using on clause?

952

how to get a list of columns in an existing table? : Sql dba

964

Can unique keys be null?

908

How global cursor can be declare with dynamic trigger ?

2210