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

find out the third highest salary?

Question Posted / sukanya

92 Answers
153823 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

Answer Posted / sukanya

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2196

Can group functions be mixed with non-group selection fields?

1073

How to select all columns of all rows from a table in oracle?

1104

What is the difference between sharding and replication?

1138

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1070

What are data pump export and import modes?

1112

What are the differences between char and varchar2 in oracle?

1249

How to define an oracle sub procedure?

1232

How to insert multiple rows with one insert statement in oracle?

1134

How to pass a parameter to a cursor in oracle?

1231

What is sequence?

1136

What are the differences between char and nchar in oracle?

1146

How to turn on or off recycle bin for the session?

1174

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2314

What is save point in oracle database?

1366