Answer / sheela

Select top 2 sal from (select sal from emp order by sal
desc)

Answer / dsr

query:
======
select e.name,e.salary from emp e where &n =(select
count(distinct ee.salary) from emp ee where e.salary<=e.salary)

after run enter n value:

if 2 enter second max salary will come
if 3 enter third max salary will come.

otherwise, we can write below

select e.name,e.salary from emp e where 2 =(select
count(distinct ee.salary) from emp ee where e.salary<=e.salary)

Answer / nitin

SQL> select emp_sal from (select emp_sal from nitin order
by emp_sal desc) group by rownum,emp_sal
having rownum=2;

Answer / rahul thakur

select top 1 salary from emp where id not in (select top1 id from emp order by salary desc)order by salary desc.

Answer / mastan

select name,salary from (select salary from emp order by
salary desc)where rownum<2

Answer / jyotiprokash

Select * from emp e1 where 1=(select count(distinct sal) from emp e2 where e1.salary<e2.salary)

Answer / raja

first find third maximum
then it ll be very easy to find second maximum.. :)

Answer / em rao

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

Answer / kameshwar shukla(a.i.e.t l.k.o

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

Answer / khushbu

select max(salary) from emp where salary not in (select
max(salary) from emp)

Which data dictionary views have the information on the triggers that are available in the database?

0 Answers  

What are character functions?

0 Answers  

How to download oracle sql developer?

0 Answers  

What is the basic structure of an sql?

0 Answers  

What is sql keyword?

0 Answers  

Mention what is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1 Answers   ABC,

How you will create Toad Function?

1 Answers  

How do I filter in sql profiler?

0 Answers  

How many rows will return from dual table?

4 Answers   Fujitsu,

Explain clause in sql?

0 Answers  

What is sqlite used for?

0 Answers