Answer Posted / 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)

What is the sql query to find the employee who has Nth maximum salary?

4288

---

as a technical developer in oracle applications which type errors feced in your experience sofar

1907

---

Explain how to close periods in ar. : oracle accounts receivable

707

---

Give two methods you could use to determine what DDL changes have been made.

6022

---

What is the mandatory setup in cyclecount ?

2186

---

---

HOW TO SPOT AHIERARCHY?

1849

---

What do you mean by hz_ in customer tables? : oracle accounts receivable

644

---

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

2139

---

difference of using cursor for loop and open,fetch,close.which one is better

1252

---

How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?

1920

---

What is autocashrule set? : oracle accounts receivable

735

---

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

740

---

What is auto invoicing? Explain : oracle accounts receivable

616

---

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

685

---

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

1727

---