Answer / hr@tgksolutions.com

• Use DISTINCT in queries to filter duplicates.
• Use ROW_NUMBER() to identify duplicates:
DELETE FROM Employees
WHERE id NOT IN (
SELECT MIN(id)
FROM Employees
GROUP BY name, email
);
• Implement unique constraints on key fields.

What are the differences between lov and list item?

0 Answers  

---

How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.

2 Answers   AppLabs,

---

What is a sub query and what are the different types of subqueries?

0 Answers  

---

How to convert characters to numbers in oracle?

0 Answers  

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

0 Answers  

---

What does a Control file Contain ?

2 Answers  

---

How to use subqueries in the from clause in oracle?

0 Answers  

---

Is oracle a programming language?

0 Answers  

---

Is oracle a relational database?

0 Answers  

---

create one table to capture an employee details with a primary key.

1 Answers   CTS,

---

How many categories of data types?

0 Answers  

---

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

4 Answers   Microsoft,

---