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

find out the third highest salary?

Question Posted / lakshmi

Answer Posted / lakshmi

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

Is This Answer Correct ?

94 Yes

135 No

Please Help Members By Posting Answers For Below Questions

What is a read only transaction in oracle?

1029

Explain an integrity constrains?

1149

How to write date and time literals in oracle?

1002

Is there a combination of "like" and "in" in sql?

1065

Describe the types of sub query?

997

query optmization techniques and quwry analyser+projects+ppts

2421

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2325

How to set a transaction to be read only in oracle?

1093

Can you assign multiple query result rows to a variable?

987

What are the various types of snapshots ?

1029

What do you mean by a deadlock?

1065

What is translate in oracle?

1098

What are the common oracle dba tasks?

1147

How to create a new tablespace in oracle?

987

What is a view and how is it different from a table?

1045