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
Explain verification?
What the different types of test coverage techniques are?
Explain exit criteria?
An input field takes the year of birth between 1900 and 2004 what the boundary values for testing this field are?
what r the strategies & methodologies r u following in preperation of test cases based on usecase?
What is disaster recovery testing?
Why we need localization testing?
Mention what are the categories of defects?
What is maintenance testing?
How will you log a Defect when you are in the process of executing a test case?
What is test specification?
What is quality system?
What is test environment?
What is policy?
During which test activity could fault be found most cost-effectively?