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

find out the third highest salary?

Question Posted / harikrishna ravipati

Answer Posted / harikrishna ravipati

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to define an anonymous procedure without variables?

1107

What is the difference between formal parameters and actual parameters?

1088

Difference between hot backup vs. Cold backup?

991

How many data types are supported?

1079

What are the differences between interval year to month and interval day to second?

1026

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2025

How to connect to the server with user account: sys?

1017

candidate key is subset of super key but not vice-verse explain

2068

What is the difference between Delete, Truncate and Drop in Oracle?

1131

What happens if you set the sga too low in oracle?

1150

What is recovery manager in Oracle?

1056

What is the difference between truncate & delete command?

1182

How to define default values for formal parameters?

1044

What is the max number of columns in an oracle table?

999

How can windows applications connect to oracle servers?

1057