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 the best partition size for windows 10?

704

Does varchar need length?

712

what is foreign key? : Sql dba

750

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

701

What is difference between stored procedures and application procedures?

764

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1156

What are all the different normalization?

744

What is the difference between local and global temporary table?

753

Does db2 use sql?

673

What is before and after trigger?

691

What is pessimistic concurrency control? : Transact sql

831

What is a function in oracle pl sql?

721

what is the difference between join and union? : Sql dba

719

Why is stored procedure faster than query?

700

what are all the common sql function? : Sql dba

779