Answer Posted / prasanna

DELETE FROM
(SELECT EMP_ID, SALARY, DENSE_RANK() OVER (ORDER BY SALARY
DESC) AS CNT FROM EMPLOYEE)
WHERE CNT = 3;

or

delete from employees where employee_id in (select
employee_id from employees where 2 =(select count(distinct
e.salary) from employees e
where e.salary > employees.salary));

How to use subqueries in the from clause in oracle?

1045

---

Is oracle the best database?

915

---

Is a rollback possible to any savepoint?

1002

---

6. Display the client name and order date for all orders using the traditional method.

2242

---

Explain what does a control file contain?

1034

---

What is index in Oracle?

1014

---

What do database buffers contain?

964

---

definition of cluster and non-clustered index?

2962

---

What are the attributes that are found in a cursor?

1013

---

Explain what are the uses of rollback segment?

961

---

How does Oracle guarantee data integrity of data changes?

2333

---

How to update values on multiple rows in oracle?

975

---

What is an anonymous block?

1158

---

What is the data pump import utility?

969

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2130

---