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 schema in sql example?

1270

What is a dynamic query?

1064

What does sign mean sql?

1173

Can we call stored procedure in function?

998

Explain the the delete statements in sql?

1108

How do I write a cron which will run a sql query and mail the results to agroup?

1027

Can we insert delete data in view?

990

Are sql connections encrypted?

1076

Differentiate between sga and pga.

1204

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1123

What does trigger mean in slang?

1119

Can I join the same table twice?

1090

What is execute immediate?

1155

What is the non-clustered index in sql?

1102

explain about mysql and its features. : Sql dba

1047