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 some primary characteristics of teradata?

1048

What do you mean by teradata sql assistant?

1109

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1250

What do you mean by teradata intelliflex?

1163

What is bteq utility in teradata?

1023

What is partitioned primary index (ppi)?

1086

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

1097

What type of indexing mechanism do we need to use for a typical data warehouse?

1222

What are the advantages of teradata?

1055

Highlight a few of the advantages that ETL tools have over Teradata.

1131

What are some commonly used bteq scripts?

1056

How to view every column and the columns contained in indexes in teradata?

1095

How do you define Teradata?

1082

What is spool space? Why do you get spool space errors?

1076

What exactly do you know about catching in teradata?

1075