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 is bteq utility in teradata?
What is upsert statement in teradata?
What are the joins in teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
Explain the parallel data extension in teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
What are default access rights in teradata?
How to find duplicates in a table?
Discuss the advantages of using partitioned primary index in a query?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What is a dimension table?
How to view every column and the columns contained in indexes in teradata?
Why do you get spool space errors? How do trouble-shoot them?
What are the various indexes in teradata? How to use them?
How do you set the session mode parameters in bteq?