Answer Posted / suren

hi Im SureRishi

SELECT *
FROM Employee E1
WHERE (4-1) = (
SELECT COUNT(DISTINCT(E2.Salary))
FROM Employee E2
WHERE E2.Salary > E1.Salary)

what is the difference between functional dependecy and multilevel dependency?

2519

---

please explain.. DB architecture ...

2081

---

State all possible different index configurations a table can possibly have?

1102

---

What is Segment Advisor in Oracle?

1146

---

What is oracle sid?

1005

---

List the various oracle database objects?

1111

---

What are the oracle built-in data types?

1135

---

How to rename an index?

1124

---

How can we view last record added to a table?

1105

---

How to start your 10g xe server from command line?

1127

---

What are the original export and import utilities?

1259

---

How to end the current transaction in oracle?

1071

---

how can we store any pdf file in oracle

2220

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1134

---

How to use null as conditions in oracle?

1126

---