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
- 59024 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 is basic teradata query language?
How many tables can you join in v2r5?
What is meant by a Parsing Engine?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What are the updated features of teradata?
Differentiate database data and data warehouse data?
What are the steps involved after the disk manager passes the request?
What is the use of fallback?
How to find duplicates in a table?
Write a program to show the parser component used in teradata?
What is meant by a Channel Driver?
List out teradata data types?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What is the difference between fastload and multiload?
What are the newly developed features of Teradata?
