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

What are tpump utility limitations?

593

What are aggregate tables? How do you design them using teradata?

632

What are the different functions included in the server software?

596

What are the steps to create a data model?

594

What are types of partition primary index (ppi) in teradata?

583

Steps to create a data model?

656

Discuss the advantages of using partitioned primary index in a query?

526

Why teradata is used?

574

Difference between stored procedure and macro?

677

How can we check the version of Teradata that we are using currently?

584

What is stored procedure in teradata?

578

Describe primary index in teradata. And what are the available primary index types?

539

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

3901

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

595

What interface is used to connect to windows based applications?

580