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

Explain performance testing?

665


The purpose of the requirement phase is

736


Explain monkey testing?

644


What is test case generator?

662


What is a test closure?

658






Say your Product passed through testing and UAT. Now it went to production at client location and they found one defect in it. How they need to procced now? Will they contact you? Will they contact dev team?

686


Explain walk-through?

668


How do you verify the test results and how do you proceed when you do not get the expected results?

660


Explain error?

669


Innovative suggestions, solutions, if any, brought out by you for the better performance of the Quality and Testing department/ company during the review period: Anybody can answer to this question..Thanks in advance..venkat

2406


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?

742


What is oo function testing?

695


What is path analysis?

902


IF i have two columns in Database , While using Database output value ,allthe values in the two column are set as a single row in the QTP datatable, can u suggest me a idea so that QTP Runtime datatable displays the values as it is in the database

1632


What are the types of defects?

732