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 the difference between $ORACLE_HOME and $ORACLE_BASE.

7690

---

What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1173

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

2072

---

Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1286

---

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1156

---

Explain about party and customer in ar : oracle accounts receivable

1218

---

What is the difference between recovery and restoring of the oracle database?

1231

---

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

2289

---

Difference between negative and positive adjustments : oracle accounts receivable

1110

---

what is the link between suppliers and banks in ap module in oracle apps? And also query?

2478

---

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

1305

---

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

2300

---

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2219

---

IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?

2271

---

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

2007

---