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 interviews questions for storage domain

16032


hi..I am from Pune and i want to take ISTQB.So pls tell me which book i should refer and sample papers?How much time i need to prepare for it?Those who have material pls help me out and mail me at pankaj_r_autela@yahoo.com , And those who are from Pune and have taken this exam ,i vl like to share your knowledge. Thanks in Advance to all of you.. Pankaj

1509


What is coverage measurement?

671


Explain what n+1 testing is?

700


Which activity in the fundamental test process includes evaluation of the testability of the requirements and system?

751






What is integration testing in software testing?

578


What is the difference between web application and desktop application in the scenario of testing?

615


What is the main benefit of designing tests early in the life cycle?

667


what is the role of external testing companies?

1608


I. Requirements are formally reviewed. II. Requirements are formally approved. III. Requirements are placed under configuration control. IV. Requirements are implemented in code. Using the above statements, when are requirements considered baselined? 1. I and II 2. I, II, and III 3. I, II, III, and IV 4. I only 5. I, III, and IV

1889


What is random/monkey testing? When is it used?

600


What is loop testing?

609


what do i expect in a second interview for a system tester position

1524


What is error-based testing?

610


What is a utility?

674