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

what are the interviews questions for storage domain

16297


What is a user friendly document?

811


What are the emerging trends in the testing and QA arena?

2075


When usin qtp iam able to get the data from the database only in a single row that is if i have 2 columns in database,when using database output value , all the values in Database are transfered to a single row in QTP datatable. I want the values to appear as it is from the database , can anyone suggest some ideas?

1692


How to track the requirement from bugzilla tools? As our project requirement are changing frequestly and all are tracked in bugzilla tool. How to manage all as all project having short term duration. Please reply back ASAP? Thanks in advanced?

2036


Why we use decision tables?

849


What is integration testing in software testing?

803


How will you log a Defect when you are in the process of executing a test case?

1905


What is test case generator?

792


what is the difference between the normal testing and embedded testing?

829


Explain error?

783


What is called the process starting with the terminal modules?

842


What is the key difference between preventative and reactive approaches to testing?

808


As part of which test process do you determine the exit criteria?

1303


Could anyone let me know what exactly is telecom testing & how is it done? And also how is mainframe testing done?

1712