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

find out the third highest salary?

Question Posted / mahesh

Answer Posted / mahesh

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

Is This Answer Correct ?

11 Yes

10 No

Please Help Members By Posting Answers For Below Questions

How to list all tables in your schema?

1053

What are group functions in oracle?

1038

What is a synonym? What are its various types?

1108

Give the various rollback segment states.

1052

How to assign data of the deleted row to variables?

1072

Explain parameter file in oracle.

1027

Explain the use of record length option in exp command.

1067

What is the purpose of save points in oracle database?

1114

What is hash cluster in oracle?

1171

What is the fastest query method to fetch data from the table?

1357

How to synchronize 2 schema's objects?

2178

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2310

How to create a table index?

1146

List the parts of a database trigger.

1049

How can Oracle users be audited?

1109