Interested to Buy Any Domain ? << Click Here >> for more details...
How do you handle duplicate records in a database?
- 1 Answers
- 1073 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 oracle data type?
is there a tool to trace queries, like profiler for sql server?
How to call a stored procedure inside a trigger? Give an example.
How to export several tables together?
What is set operator oracle?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Differentiate between post-database commit and post-form commit?
what is a view?
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
Explain the use of owner option in exp command.
How to define a procedure inside another procedure?
Oracle General 
