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 many sql commands are there?

1102

How do you pronounce sql?

989

How to call a javascript function from pl sql?

1119

Explain the insert into statements in sql?

984

Show the two pl/sql cursor exceptions.

1167

Why is a trigger used?

926

What are the ddl commands?

990

What is dialect in sql?

925

What is sql injection owasp?

1040

Explain how exception handling is done in advance pl/sql?

986

What is a database trigger?

1050

Explain what is sql?

1098

How do you use a while loop in pl sql?

998

Which version of sql do I have?

1037

How can we implement rollback or commit statement in a trigger?

1017