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

Explain cascading triggers.

0 Answers  

What are the original export and import utilities?

0 Answers  

What is the difference between primary key and unique key and foreign key in oracle?

0 Answers  

What do you mean by cdb and pdb in oracle 12c?

0 Answers  

write a query that displays every Friday in a year with date?

5 Answers   Flipkart, HCL, TCS,

How to end the current transaction in oracle?

0 Answers  

What is a named program unit?

0 Answers  

What does `(+)` do in a where clause?

1 Answers  

How to update values on multiple rows in oracle?

0 Answers  

What happens if recursive calls get out of control?

0 Answers  

How to set a transaction to be read only in oracle?

0 Answers  

Can we create more than one index on particular column?

1 Answers