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

Which activity in the fundamental test process includes evaluation of the testability of the requirements and system?

747


HI friends, I am planning to take up foundation level ISTQB Certification exam in March. Anybody having the study materials and sample papers please mail sunkumaranr@gmail.com Thanks in Advance...

1619


In real time how you do the soak testing?

544


Explain testing?

592


Best institute for protocol testing in Hyderabad ? How will be the market for protocol testing ?

1789






Mention what the difference between pilot and beta testing is?

573


What is test/qa team lead?

576


What is static analysis?

617


Metrics of your Project?

1723


Explain what test plan is?

607


Explain installation testing?

616


What is bottom-up testing?

598


How many test cases will be there for testing the numbers of range -10.0 to 10.0? How it is classifying?

1649


Please Check out and Answer the Questions in Networking section. It's argent.

1651


what is the role of external testing companies?

1606