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 a unique key and primary key and foreign key?

1020

what is the difference between char and varchar data types? : Sql dba

1169

What is the purpose of the partition table?

1089

How do sql triggers work?

1090

What is sql not null constraint?

1092

What are properties of the transaction?

1045

What are the two virtual tables available at the time of database trigger execution?

1270

What is secondary key?

984

What is the difference between left and left outer join?

991

What is pl sql variable?

1034

Is a table valued function object?

1073

What is pl sql block structure?

1090

How delete all data from all tables in sql?

983

How many tables can you join in sql?

1006

what are the advantages of sql ? : Sql dba

1105