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 are the interviews questions for storage domain
What is a user friendly document?
What are the emerging trends in the testing and QA arena?
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?
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?
Why we use decision tables?
What is integration testing in software testing?
How will you log a Defect when you are in the process of executing a test case?
What is test case generator?
what is the difference between the normal testing and embedded testing?
Explain error?
What is called the process starting with the terminal modules?
What is the key difference between preventative and reactive approaches to testing?
As part of which test process do you determine the exit criteria?
Could anyone let me know what exactly is telecom testing & how is it done? And also how is mainframe testing done?