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;

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

1 Answers  

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

0 Answers   Infosys,

the user should know to which database he is connected currently in oracle

3 Answers  

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

0 Answers   Pathway Technologies,

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers   IBM,

How would you determine the time zone under which a database was operating?

1 Answers  

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 Answers  

Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

0 Answers  

Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha

0 Answers  

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

1 Answers  

Explain the payment term in ar. : oracle accounts receivable

0 Answers  

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers