select distinct sal from table_name t1 where 4=(select count(distinct sal)

write a query to find 4th max salary

Question Posted / nishi.swain@gmail.com

select distinct sal from table_name t1 where 4=(select count(distinct sal) from table_name t2 where
t1.sal<=t2.sal);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What version is sql?

966

What is natural join in sql?

918

What does count (*) mean?

875

What is the purpose of design view?

952

what are the difference between clustered and a non-clustered index? : Sql dba

979

What sql database should I use?

1075

What is trigger point?

950

Why having clause is used in sql?

931

Can we group by two columns in sql?

946

What is count * in sql?

936

Can cursors be part of a trigger body?

1588

Which are sql * plus commands?

1043

What are field types?

942

Can we perform dml on view?

976

What is meant by truncate in sql?

1008