select * from emp where 2-1=(Select count(distinct(sal) from emp e where

i want to know about mr.b.kotravel......who has answered
for second maxmium salary from employee table

Question Posted / surya

Answer Posted / surya

select * from emp where 2-1=(Select count(distinct(sal)
from emp e where emp.sal<e.sal and ename='mr.b.travel)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain parameter file in oracle.

1081

How to rename a column in an existing table?

1083

What are the logical operations?

1170

How do you store pictures in a database?

1058

Explain what does a control file contain?

1165

Which are the five query types available in oracle?

1000

How to initialize variables with default values?

1307

What is a table in oracle?

1022

What is a tns file?

1043

What is raw datatype?

1189

Give the constructs of a package, function or a procedure.

1096

how to do daily transactions with out sql* loader control file regesterd in apps?

1730

What is a package ? What are the advantages of package ?

1136

What are the four Oracle system processes that must always be up and running for the database to be useable?

1051

Difference between hot backup vs. Cold backup?

1039