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 delete a column in an existing table in oracle?

1130

What is meant by joins?

1109

Is rowid unique in oracle?

1048

How to create a table in a specific tablespace?

1029

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2320

What is the difference between translate and replace in oracle?

1218

How many categories of data types in oracle?

1075

How to use an explicit cursor without open statements?

1103

definition of cluster and non-clustered index?

3106

How to retrieve the count of updated rows?

1194

How to convert csv to table in oracle?

1048

How to Truncate Table in Oracle

1216

What are the different windows events activated at runtime ?

2945

What is transaction control statement and how many types of transaction control statement in Oracle?

1236

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2173