select max(sal) from emp where sal!=(select max(sal) from emp where sal!=(

Find out the 3rd highest salary?

Question Posted / jagdish

Answer Posted / jagdish

select max(sal) from emp where sal!=(select max(sal) from
emp where sal!=(select max(sal) from emp))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you create an update query?

917

Is inner join same as self join?

1064

How does join work in sql?

962

Explain aggregate functions are available there in sql?

943

What is the use of prepared statement?

953

What is trigger price?

926

What is difference between primary and secondary key?

976

Can we enter data in a table in design view?

913

What are stuff and replace function?

1017

Which table is left in join?

916

What mean sql?

954

how to get help information from the server? : Sql dba

878

How to find 3rd highest salary of an employee from the employee table in sql?

1038

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1005

What is the difference between execution of triggers and stored procedures?

1053