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

What is a synonym? What are its various types?

1108

How to create an oracle database?

1039

How to execute the package in oracle?

1081

How to drop a stored procedure in oracle?

1051

How do I uninstall oracle 11g?

1115

How do we represent comments in oracle?

1046

How can we view last record added to a table?

1038

State the various uses of dbcc command?

1058

Will you be able to store pictures in the database?

1118

How to call a stored function in oracle?

1018

What is a lookup table in oracle?

973

How to commit the current transaction in oracle?

1118

Can we use bind variables in oracle stored procedure?

948

What are the differences between char and varchar2 in oracle?

1169

What is the order of defining local variables and sub procedures/functions?

1061