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

What are the common mistakes which create issues?

616


Explain sanity testing?

565


What is difference between JBOD and RAID?

1657


What are the Difficulties you found while testing your module ? plese give the possible difficulties.

1993


i want learn "itesting tool"....which is best institutes to learn "itesting tool" in hyderabad or banglore ?plz give me reply as soon as posible?

1567






Explain what it means by test harness?

629


What is scenario-based testing?

589


What is memory leaks and buffer overflows ?

642


What is test management review and why it is important?

531


What is static analyzer?

594


Explain error?

575


What is checksheet?

641


I need to learn everything I can about the different types of Test Activities (i.e., Test Strategy, Test Plan, Test Cases, etc.). What is the best online resource?

647


How to write an implementation plan for our QA system with small budget, from scratch.

1667


Hi,can anyone help me with sap testing.how is sap testing done

1591