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;

wht r the base tables & primary key for BOM& WIP modules

1 Answers   Satyam,

Can we get the deleted Record again if the delete transaction has been committed.

4 Answers  

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

1 Answers   Oracle,

how can we send a concurrent program output to the clients through mail or fax give me example.

1 Answers   Cap Gemini,

How would you go about generating an EXPLAIN plan?

1 Answers   Satyam,

What is database schema?

4 Answers   Infosys,

1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

0 Answers   Cap Gemini,

What command would you use to create a backup control file?

1 Answers  

Is there any link between pr form(purchse requisition)and po form(purchase order)

0 Answers   L&T,

I would like to study certification course in Data base adminidtrator then where would i go to study this course?

0 Answers  

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

8 Answers  

what is semphore explian it?

0 Answers   IBM,