Select Column_name from table_name group by column

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

Question Posted / uma

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

Please Help Members By Posting Answers For Below Questions

In white box testing, what do you verify?

1427

What it means by test harness?

1012

What the difference between pilot and beta testing is?

984

What is pdr - peer design review?

1068

What is software bug?

1117

What is flowchart?

1006

Explain code inspection?

1085

What is a system administrator?

1041

Explain ad hoc testing?

1033

What is eexception?

1053

What is quality policy?

1068

What is problem?

1011

Explain automated testing?

1053

Hi All!!Can anyone please suggest some better website to learn Mainframe Testing??Am very much new to Mainframes. Thanks in Advance Nithya

1732

What are enter & exit criterias of a test paln?

1191