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.
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 |
Post New Answer View All Answers
List the logical and conditional operators that are used with teradata along with their meanings?
What happens when a node suffers a downfall?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What interface is used to connect to windows based applications?
What are the functions of a Parser?
How many types of joins are there in teradata?
How to load specific no.of records using bteq, or fastload,or multiload
How to identify ppi columns?
What are some commonly used bteq scripts?
What is the opening step in basic teradata query script?
How is MLOAD Client System restarted after execution?
What is teradata? What are some primary characteristics of teradata?
Explain the types of join supports by teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What are the available join types in teradata?