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

How many sql core licenses do I need?

994

Is left join faster than join?

1096

what is meant by nl2br()? : Sql dba

1105

What is relationship? How many types of relationship are there?

1261

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1062

What are analytic functions in sql?

1072

What is the usage of nvl function?

1100

Why stored procedures are faster than query?

1076

What are all the different types of indexes?

1195

What are character functions?

1138

Can we create view in stored procedure?

1022

Explain what is a column in a table?

1156

What is a database event trigger?

1210

Is sql microsoft?

1103

What is an exception in PL/SQL? What are the two types of exceptions?

1395