Interested to Buy Any Domain ? << Click Here >> for more details...
How do you handle duplicate records in a database?
- 1 Answers
- 1011 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 |
how do u setup a replication site?
i want department wise maxmum salary and empolyee name
What is Trace File ?
How to fetch the row which has the max value for a column?
What are transaction isolation levels supported by oracle?
How to change user password in oracle?
How to start a new transaction in oracle?
Describe the different type of Integrity Constraints supported by ORACLE ?
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
IS it possible to built the oracle database without setting the kernal parameters?
What is a Synonym ?
How to load excel data sheet to oracle database
Oracle General 
