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 exception is different from error?

1019

differentiate between float and double. : Sql dba

1060

What is sql and also describe types of sql statements?

1066

What are the types of functions in sql?

1020

Explain character-manipulation functions?

1134

What is pl sql variable?

992

What is AUTH_ID and AUTH_USER in pl/sql ?

2193

Can a foreign key have a different name?

940

Name the different types of indexes in sql and define them.

1151

How does rowid help in running a query faster?

1416

Is it possible to create startup or shutdown trigger for on-schema?

1029

Why is sql*loader direct path so fast?

1104

Can we use pl sql in sql server?

1084

Can we insert data into materialized view?

945

What is sqlerrm?

939