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
What are some primary characteristics of teradata?
How is MLOAD Teradata Server restarted after execution?
How do you verify a complicated sql?
What is a node in teradata? Explain
What is oltp?
What are the frequently used data types in teradata?
What is the use of fallback?
What do you mean by teradata intelliflex?
Discuss the advantages of using partitioned primary index in a query?
What are the steps involved in the process flow of the sql statement through channel attached system?
What is partitioned primary index (ppi)?
What is basic teradata query language?
Difference between multiload and tpump?
What is the use of teradata system software?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?