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

What are different joins used in sql?

1055

What is auto increment?

997

Explain the working of foreign key?

1067

how do you know the version of your mysql server? : Sql dba

1004

What is auto increment in sql?

1121

explain the delete statements in sql

1056

Can we update views in sql?

938

Can we insert data in view?

962

Where not exists in sql?

978

what is 'mysqld'? : Sql dba

967

What is the difference among union, minus and intersect?

1000

What is difference between function and trigger?

1047

What programs use sql?

1004

How do you rename a table in sql?

1109

what is view? : Sql dba

956