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


Please Help Members By Posting Answers For Below Questions

hello frnz when we r testing cookies for security testing in that we have to check for deleting cookies my ques is do we have to delete from browser(google chrome m using) or from hard drive? reply soon thanx

1732


What is the difference between the white box, black box, and gray box testing?

805


what is system testing?

1800


How we will do DataBase testing through Qtp application, i know two things 1)Import date from sheet2)Database Check points. But Interviewr asked me How to Run Queries from Qtp Application?Plz Any Body Exlain about Data Base Testing.Urgent.........Advanced Thanks

1739


What is your primary role in your project?

2418


hi,iam learning testing tools in mindq.i want to put 2+exp. is there any problem with that. tell me what are the Interview questions for experienced peopole. please give me the answer. thanq

2739


What does a typical test report contain? What are the benefits of test reports?

1132


What is the difference between test matrix and traceability matrix?

852


How does a test coverage tool work?

978


Metrics of your Project?

1928


What are the maximum no. of devices supported in SCS-1,2 and 3?

1660


What is the bottom-up approach?

885


What is coverage analysis?

846


How would you estimate the amount of re-testing likely to be required?

979


What are validation and verification?

868