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
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
What is the difference between the white box, black box, and gray box testing?
what is system testing?
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
What is your primary role in your project?
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
What does a typical test report contain? What are the benefits of test reports?
What is the difference between test matrix and traceability matrix?
How does a test coverage tool work?
Metrics of your Project?
What are the maximum no. of devices supported in SCS-1,2 and 3?
What is the bottom-up approach?
What is coverage analysis?
How would you estimate the amount of re-testing likely to be required?
What are validation and verification?