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 TNS File

7 Answers   Thermotech,

What is Hash Cluster ?

2 Answers  

What is system tablespace?

0 Answers  

What are the restrictions in a oracle read only transaction?

0 Answers  

How can we view last record added to a table?

0 Answers  

What is integrity and what is constraint??Explain with example

0 Answers   Google,

How can we Update a table with out using UPDATE command?

1 Answers  

Can you create a synonym without having a table?

0 Answers  

How to name query output columns in oracle?

0 Answers  

What is the difference between Outer join and Full outer join?

5 Answers  

The join defined by the default data link is an outer join yes or no ?

1 Answers   Oracle,

What is the difference between sharding and replication?

0 Answers