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
Which activity in the fundamental test process includes evaluation of the testability of the requirements and system?
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...
In real time how you do the soak testing?
Explain testing?
Best institute for protocol testing in Hyderabad ? How will be the market for protocol testing ?
Mention what the difference between pilot and beta testing is?
What is test/qa team lead?
What is static analysis?
Metrics of your Project?
Explain what test plan is?
Explain installation testing?
What is bottom-up testing?
How many test cases will be there for testing the numbers of range -10.0 to 10.0? How it is classifying?
Please Check out and Answer the Questions in Networking section. It's argent.
what is the role of external testing companies?