select * from emp where sal<(select max(sal) from emp where sal<(sel

find out the third highest salary?

Question Posted / punit chauhan

Answer Posted / punit chauhan

select * from emp where sal<(select max(sal) from emp
where sal<(select max(sal) from emp))

punit chauhan
iMS NOIDA
doing MCA

Is This Answer Correct ?

12 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why oracle is used?

1065

How to change user password in oracle?

1038

How to write text literals in oracle?

1073

What is the relation of a user account and a schema?

1134

What is different types of joins?

1026

What privilege is needed for a user to query tables in another schema?

979

What is catalog in Oracle?

1375

Explain the features of oracle?

1057

How to drop an existing table in oracle?

1062

What are named parameters?

1098

How do I connect to oracle database?

1129

Explain oracle instance.

1187

What are group functions in oracle?

1049

How can we view last record added to a table?

1044

What is meant by joins?

1068