How to delete duplicates records in teradata without any
tables....?
with only one single query,,,?
Answer Posted / jain
DELETE FROM table_name A WHERE ROWID > (SELECT min(rowid)
FROM table_name B WHERE A.key_values = B.key_values)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is eexception?
What are test comparators?
Explain inputs?
how to attach and detach databases in sql?
What is cause-effect graphing?
Examples where you have worked on your own and as part of a team.
What is test driver?
What is storage virtualization?
How many effort estimation methods available in market for testing?
What are validation and verification?
What is independent test group (itg)?
During the testing of a module tester, 'x' found a bug and assigned it to a developer. But developer rejects the same, saying that it's not a bug. What 'x' should do?
Faults found should be originally documented by whom?
What is the main goal of defect prevention meeting?
I Want To Join Infrasoft Technologies,what is the Procedure To Join The Company?