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;

Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

0 Answers  

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

0 Answers   Infosys,

Difference between negative and positive adjustments : oracle accounts receivable

0 Answers  

What are the mandatory setups in setting up a PO in oracle

1 Answers   Silicon,

A scenario for amount correction & how to use amount correction functionality in AP invoices

0 Answers  

hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.

1 Answers  

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

0 Answers   jusco,

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers   Alshaya,

Are These Dff's Flexible?

0 Answers   Oracle,

Where would you look for errors from the database engine?

2 Answers   Fintellix,

How do you add a data file to a tablespace?

1 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,