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)

What is rank function in sql?

0 Answers  

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 Answers  

how to convert numeric values to character strings? : Sql dba

0 Answers  

What are the topics in pl sql?

0 Answers  

Does sql profiler affect performance?

0 Answers  

how does a local variable is defined using t-sql? : Transact sql

0 Answers  

What is the non-clustered index in sql?

0 Answers  

how to convert character strings to dates? : Sql dba

0 Answers  

What is ttitle and btitle?

0 Answers  

Can we use distinct and group by together?

0 Answers  

What will be the output for the below Query Select 'High' from dual where null = null;

12 Answers   Infosys, Satyam,

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

0 Answers