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
- 59225 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
What are the functions of a teradata dba?
What are the functions involved in shared information architecture?
What is node? How many nodes and amps used in your previous project?
What are the different functions included in the server software?
Steps to create a data model?
What exactly do you know about catching in teradata?
In BTEQ, how are the session-mode parameters being set?
What is the use of fallback?
What is smp and mpp platforms?
What do you mean by fastexport in teradata?
What do you mean by teradata sql assistant?
What is the maximum number of dml can be coded in a multiload script?
what are the day to day activities of teradata DBA ?
How to Extract data from multiple legacy systems?
what is object level locking ? where do appear this type of locking ?
