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 / vinay sir(datawarehousing tech
Yuva,Nice to see your answers.I hope we can't use "Ordered
Analytical Queries in Where Clause".So first answer may not
be correct.Please check and let us know.
2nd way is one of the way where we are using intermediate
table to delete duplicates.
Any way thank you much Yuva for your nice postings.
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What are different table types used in teradata?
Explain fallback in teradata?
What do you mean by teradata intelliflex?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is the use of stored procedures in teradata?
What does sleep function does in fast load?
Explain some differences between mpp and smp?
How many tables can you join in v2r5?
Explain teradata utilities. What is multiload, fast load, tpump?
Mention a few of the ETL tools that come under Teradata.
What can be achieved by using the teradata rdbms?
How to select first n records in teradata?
What is teradata? What are some primary characteristics of teradata?
What is the syntax for case when statement?
Difference between multiload and tpump?