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 code review?
What is software fault?
Metrics of your Project?
what is cohensive testing and span control?
What is equivalence partitioning testing?
What is applications of FCOE?
what is the main purpose of informal review
What is the main goal of defect prevention meeting?
i am fresher in manual testing.how to do database testing as a manual tester.suggest me some answers,so that i will have a clear idea adout database testing.
What are the main constrains of SCSI in storage networking?
What is test result analyzer?
i am a PG science(chemistry),now am working test engineer in small organization,now i will decide to move better organization please send model cv and advises
Test report?
Testing activity which is performed to expose defects in the interfaces and in the interaction between integrated components is?
What is process and procedures?