How do you handle duplicate records in a database?
- 1 Answers
- 466 Views
- I also Faced
- E-Mail Answers
• 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a Segment ?
How to connect to oracle using service name instead of sid?
When can Hash Cluster used ?
How to drop an index?
How to use group functions in the select clause using oracle?
How to assign values to variables?
State all possible different index configurations a table can possibly have?
Can a property clause itself be based on a property clause ?
How many types of auditing in Oracle?
What is the order of defining local variables and sub procedures/functions?
How to create an oracle testing table?
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
Oracle General 
