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

Answer Posted / suganya

SELECT DISTINCT column_name(s)
FROM table_name

Is This Answer Correct ?    9 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the information that should be covered in test plan?

787


What is difference between JBOD and RAID?

1883


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

2201


Explain cause effect graph?

812


Explain end-to-end testing?

824


Explain metric?

815


What is vdd - version description document?

811


What are the structure-based (white-box) testing techniques?

849


What is a system administrator?

820


What is incremental analysis?

810


What is the difference between interoperability and compatibility testing with some examples?

939


Hi can anyone guide me regarding how the interview procedures will be in exterro Inc, Coimbatore

1884


How do the companies expect the defect reporting to be communicated by the tester to the development team. Can the excel sheet template be used for defect reporting. If so what are the common fields that are to be included who assigns the priority and severity of the defect.

999


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

1777


What is what are the parameters of performance testing?

816