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 happens if variable names collide with table/column names?

1191

How do we get field details of a table?

978

What is blob data type in oracle?

1123

Please explain oracle data types with examples?

1069

How to start instance with a minimal initialization parameter file?

1040

What is null value in oracle?

1097

What is the difference between "as" and "is" in an oracle stored procedure?

991

what happened to the global index when I truncate the data in one of the partition?

2022

Describe varray?

1058

How to unlock the sample user account in oracle?

1016

Can we commit inside a function in oracle?

964

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2969

How to revoke create session privilege from a user in oracle?

1018

What are the uses of synonyms?

1138

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

1015