How to delete duplicates records in teradata without any
tables....?
with only one single query,,,?

Answer Posted / uma

Select Column_name from table_name group by column_name having count(column_name)>1

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In the 7 Stages of the SDLC (Planning, System Analysis, System Design, Development, Testing, Implementation, and Maintenance), WHO are the stakeholders of each stage?

831


What is test phase?

807


What is the major problems you resolved during your testing process?

1997


Explain what test plan is?

847


what is the role of external testing companies?

1814


What is life cycle?

807


Explain cyclomatic complexity?

879


Test report?

800


What is path testing?

914


How many effort estimation methods available in market for testing?

718


what is the difference between black box testing and white box testing?

826


What is static analysis?

851


How can I get free .NET add-in for QTP9.2. What is the process to install any add-in?

2171


What are the experience-based testing techniques?

802


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...

1845