How do you handle duplicate records in a database?

Question Posted / hr@tgksolutions.com

1 Answers
1067 Views
I also Faced
E-Mail Answers

How do you handle duplicate records in a database?..

• 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

Post New Answer

More Oracle General Interview Questions

How to select some rows from a table in oracle?

0 Answers

what is the syntax of SELECT command?

6 Answers

Explain do view contain data?

0 Answers

Please explain oracle data types with examples?

0 Answers

i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

7 Answers HCL, IBM,

What is mean by Program Global Area (PGA) ?

9 Answers Bajaj,

How many types of auditing in Oracle?

0 Answers MCN Solutions,

What is a deadlock ? Explain .

1 Answers

How to select an oracle system id (sid)?

0 Answers

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

0 Answers

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

0 Answers iFlex,

What are the major difference between truncate and delete?

0 Answers

For more Oracle General Interview Questions Click Here