Interested to Buy Any Domain ? << Click Here >> for more details...
How do you handle duplicate records in a database?
- 1 Answers
- 1063 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 to drop a stored procedure in oracle?
how can we store any pdf file in oracle
how to retrieve daily sal from emp table in oracle 10g
13. Display the second to fifth characters in each client name.
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to create index-by table in oracle?
How to load a large xml file?
Is the After report trigger fired if the report execution fails ?
What is dynamic proxy?
Explain the use of Merge statement in oracle 11g
what are views?
What are triggers?Where are they used?
Oracle General 
