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
- 59628 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
any one answer me how they can analyzing the project using data ware housing?
What is the difference between teradata and basic rdbms?
How do you set the session mode parameters in bteq?
Comment whether bottleneck is an error or not.
What are the functions involved in shared information architecture?
What do you mean by tpt in teradata?
What are the frequently used data types in teradata?
What is the function of parser component in teradata?
What is logical data model?
What is stored procedure in teradata?
What is meant by a Clique?
What is the command in bteq to check for session settings ?
What are the various indexes in teradata? Why are they preferred?
How do you do backup and recovery in teradata?
What is the purpose of joins in teradata and what are the available join types?
