Interested to Buy Any Domain ? << Click Here >> for more details...
How do you handle duplicate records in a database?
- 1 Answers
- 1038 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 control file used for?
How to export data to a csv file?
How to view existing locks on the database?
Hi, I want table structure shown below. How can i create this ? Num Name Address Addr1 Addr2 I want Addr1 and Addr2 under Address column. How can i achive this ? Is it possible ?
How will you write a query to get a 5th rank student from a table student_report?
What is RULE-based approach to optimization ?
What are advantages fo Stored Procedures?
types of indexes and the rationale behind choosing a particular index for a situation.
What are ACID properties in databases?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
How to define a record variable to store a table row?
How to define and use table alias names in oracle?
Oracle General 
