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)

Explain prerequisites and post activities of oracle database installation

2093

---

What is the mandatory setup in cyclecount ?

2715

---

Difference between negative and positive adjustments : oracle accounts receivable

1030

---

i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2276

---

What are different types of receipt reversals ? Explain them : oracle accounts receivable

1222

---

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2256

---

What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1270

---

What is the use of lockboxes? : oracle accounts receivable

1170

---

HOW TO SPOT AHIERARCHY?

2259

---

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1282

---

What are different types of transactions in ar? : oracle accounts receivable

1236

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2032

---

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2112

---

What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable

1241

---

we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

2460

---