Hi Vinay, Thanks ya for the catch and appre... Hi guys, Please ignore

Write a single SQL to delete duplicate records from the a
single table based on a column value. I need only Unique
records at the end of the Query.

Question Posted / yuvaevergreen

Answer Posted / yuvaevergreen

Hi Vinay,
Thanks ya for the catch and appre...

Hi guys,
Please ignore the first approach using the delete statement. It is wrong.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

In Teradata, what is the significance of UPSERT command?

1155

What is a node in teradata?

955

What are teradata utilities?

1053

How to Extract data from multiple legacy systems?

1058

how do you manage the production space. what are the proactive methods you can take ?

1894

What do high confidence, low confidence and no confidence mean in explain plan?

1001

Which is more efficient group by or distinct to find duplicates?

1055

In the Primary Index, what is the score of AMPs that are actively involved?

1024

What are the updated features of teradata?

1007

What is meant by a dispatcher?

974

How to load specific no.of records using bteq, or fastload,or multiload

1707

Describe the between keyword in teradata?

998

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2110

What are the different functions included in the server software?

995

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

977