Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 13 Answers
- 59948 Views
- I also Faced
- E-Mail Answers
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
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
How does hashing happens in teradata?
What are some commonly used bteq scripts?
How to eliminate product joins in a teradata sql query?
What are the different table types supported by teradata?
What do you mean by teradata intellicloud?
How many codd's rules are satisfied by teradata database?
any one answer me how they can analyzing the project using data ware housing?
If RDBMS is halted what will you do ?
What is the difference between fastload and multiload? Which one is faster?
What are the primary characteristics of the Teradata.
What is a three-tier data warehouse?
How is the teradata different from oracle?
During the Display time, how is the sequence generated by Teradata?
How do you define Teradata?
