Answer / ravindra

select max(sal) from emp where level=3 connect by prior sal>sal;

Answer / shrikant

SELECT MIN(sal) FROM emp WHERE
sal IN (SELECT distinct TOP 3 sal FROM emp ORDER BY sal
DESC)

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

select * from emp e
where 3 = (select count(sal) from emp
where e.sal < sal);

Select * from EMP_USER A where n-1 = (select count
(distinct (sal)) from EMP_USER B where A.sal<B.sal)

Answer / saiprasanna

select max(salary) from employ
where salary=(select max(salary) from employ where salary
<(select max(salary) from employ));

Answer / jithendranath.g

SELECT Z2.SAL FROM EMP Z1,EMP Z2
WHERE
Z2.SAL <=Z1.SAL
GROUP BY Z2.SAL
HAVING COUNT(Z2.SAL)=3

Answer / neha_gupta

select e.ename,a.sal from (select sal, rownum rnum ,rowid
rid from (select * from emp order by sal desc)) a , emp e
where a.rid= e.rowid
and a.rnum = 3

Answer / neha_gupta

select ename,sal from (select rownum rnum ,rowid rid from
emp order by sal desc) a , emp e
where a.rnum = 4
and a.rid= e.rowid

Answer / suresh

Select emp.*,dense_rank()over(order by sal desc) rn from emp
where rn=3;

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

0 Answers  

what are important reports in HRMS,GL,AP,AR in oracle apps?

3 Answers   IBM, Pathway Technologies, Satyam, Techtimer, Wipro,

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

0 Answers   Wipro,

Explain the difference between a hot backup and a cold backup and the benefits associated with each

1 Answers  

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

0 Answers  

Explain accounting for invoice in advance and arrears. : oracle accounts receivable

0 Answers  

What is Tax Categories?

0 Answers  

Can We Restore a Table that accidantly dropped.

8 Answers   TCS,

WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

0 Answers  

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

0 Answers  

Explain an ORA-01555

2 Answers  

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

0 Answers