Simple one is i think: Select min(sal) from (select sal from emp order by

write a query to find 4th max salary

Question Posted / mujahid

Answer Posted / mujahid

Simple one is i think:
Select min(sal) from (select sal from emp order by sal desc LIMIT 4);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is forward declaration in pl sql?

1086

What is varchar used for?

1085

what is the difference between truncate and drop statements? : Sql dba

1133

Explain the savepoint statement.

1102

what are the differences between char and varchar? : Sql dba

1076

What is procedure in pl sql?

1050

Is drop table faster than truncate?

996

What is a unique constraint?

1081

How do you clear the screen in sql?

1076

how to run 'mysql' commands from a batch file? : Sql dba

1122

How to fetch alternate records from a table?

1247

Which certification is best for sql?

993

what is datawarehouse? : Sql dba

1026

How to use distinct and count in sql query? Explain

1030

What is the primary use of normalization?

1010