Answer / naresh

Select * From TableName T1 Where
(N-1) = (Select Count(Distinct(E2.ColumnName))
From TableName T2 Where T2.ColumnName > T1.ColumnName)

Answer / naweed ahmad

SELECT * FROM Emp E1 WHERE n-1 =
(SELECT COUNT(DISTINCT Sal) FROM Emp E2 WHERE E1.Sal <
E2.Sal)order by Sal desc

Can anybody tell which is the best training institute for learning Oracle in chennai...? And i also i want placement assurance

1 Answers  

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

What is $FLEX$ and $PROFILES$?

2 Answers  

---

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

0 Answers  

---

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

0 Answers   L&T,

---

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

0 Answers   Pathway Technologies,

---

how to replace not in with not exist?

0 Answers   IBM,

---

Describe the P2P cycle ?

1 Answers  

---

What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?

2 Answers   CTS,

---

What is difference b/w Credit memo and Adjustment in AR.

1 Answers   Oracle,

---

When the procedures or packagess become invalidate

3 Answers   TCS,

---

Explain the process of recievables in oracle financials. : oracle accounts receivable

0 Answers  

---