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 is dcl in sql?

925

Is postgresql a server?

1013

What is partition by in sql?

1018

What are the events on which a database trigger can be based?

1144

Why are aggregate functions called so?

916

What are the set operators in sql?

1042

What is cte sql?

944

Which is faster union or join?

927

Explain the advantages and disadvantages of stored procedure?

1099

Is ms sql is free?

988

What is data manipulation language?

1156

What is the difference between a database and a relational database?

1058

Explian rowid, rownum?

975

Explain what is a view?

1014

what is view? : Sql dba

921