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 Kinds of Testing should be followed for an web application while Manual Testing . Ie., Regression , Integration , Alpha , Beta , Performance , Stress ,Load , Back End(database)...etc What is the serial way to follow the above Testing Kinds in manual testing of any application. Plz clear my doubt.

1777


What are the goals in your career as Test Engineer if u join the new compnay

5374


Is it true that we can do system testing at any stage?

760


What the difference between latent and masked defects is?

851


Explain exit criteria?

801


I need to learn who the major stakeholders are in each of the 7 stages of the SDLC. What is the best online resource?

886


What is Lun?

1857


How will you handle a conflict amongst your team members?

786


What is upward compression?

922


What is the function of the software testing tool 'phantom'?

1161


Explain configuration management?

928


What is a user guide?

805


What is web application testing

1848


What is white box testing and list the types of white box testing?

829


Faults found should be originally documented by whom?

1164