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

what are the tools used for oracle 10g in real time.

0 Answers   IBM,

---

what are important reports in HRMS,GL,AP,AR in oracle apps?

3 Answers   IBM, Pathway Technologies, Satyam, Techtimer, Wipro,

---

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

1 Answers   Oracle,

---

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 Answers  

---

wht r the base tables & primary key for BOM& WIP modules

1 Answers   Satyam,

---

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

0 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

10 Answers   TCS,

---

What view would you use to look at the size of a data file?

1 Answers  

---

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

8 Answers  

---

How would you determine who has added a row to a table?

0 Answers  

---

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

0 Answers  

---

how to display last 5 letters from a name (take emp table ename )

6 Answers   IBM,

---