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)

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

2789

---

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

1319

---

Explain the payment term in ar. : oracle accounts receivable

1150

---

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2505

---

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

2335

---

How to clone the database using RMAN back

2310

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2305

---

which one is currently in used software cmpanies.

2199

---

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2124

---

1. What is PO rate variance gain and loss?

3008

---

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

1330

---

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2333

---

What is the difference between conversions and interfaces? : oracle accounts receivable

1303

---

Why more redos are generated when the oracle database is in begin backup mode?

1169

---

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1089

---