Answer / nusrath sultana

select * from emp
where &n=(select count(distinct(sal)) from emp b
where emp.sal<=b.sal)

Answer / hari kanth

select sal from(select sal,rank() over(order by sal desc)
rnk from emp) e
where e.rnk=2;
(OR)
select rownum,sal from emp group by sal,rownum
having rownum=2;
(OR)
select rn,sal from( select rownum rn,sal from emp group by
sal,rownum order by sal desc)
where rn=2;

Answer / aravind

select * from empdetails where sal=(select max(sal) from
empdetails where sal<(select max(sal)from empdetails));

Answer / anand

SELECT SALARY FROM (SELECT SALARY FROM emp WHERE ROWNUM < 3
ORDER
BY salary) WHERE ROWNUM < 2

Answer / sikindar

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal)

Answer / amulya kumar panda

select max(salary) from employee where
salary<(select max(salary) from employee)

Answer / raunaq

to all the people who are using rownum in their queries...

This query will not work if you have more than 1 person
having the second highest salary

Answer / akash

select emp_id,sal from ( select emp_id,sal from emp where
sal < ( select max(sal) from emp) order by sal desc ) where
rownum < 2;

Answer / nagaraju

SELECT LEVEL,MAX(SAL)
FROM EMP
WHERE LEVEL IN(2,3)
CONNECT BY PRIOR SAL>SAL
GROUP BY LEVEL;

Answer / madan kumar

select *from (select empno,deptno,min(sal) from emp
group by empno,deptno,sal
order by sal desc)
where rownum<=1

What is system tablespace?

0 Answers  

"primary key=unique+null" is equal,reson?not,reason?

5 Answers  

What are Clusters ?

5 Answers   Amdocs, Infosys,

How can we find out the duplicate values in an oracle table?

0 Answers  

Display the records between two range?

2 Answers  

Explain drop constraint oracle?

0 Answers  

How to create DSN..Explain?

2 Answers   Accenture, BeBo Technologies, Infosys,

What is schema?

41 Answers   Bodhi Global Services, Cognizant, HCL,

What is the difference between online and offline backups?

0 Answers   MCN Solutions,

What is the order of defining local variables and sub procedures/functions?

0 Answers  

What is the sql query to concatenate column values from multiple rows in oracle?

0 Answers  

What is format trigger?

0 Answers