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
- 59521 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 a dimension table?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
In Teradata, how do we Generate Sequence?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is a node in teradata? Explain
Explain BYNET.
Explain fastload in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
What is the maximum number of dml can be coded in a multiload script?
How can bottlenecks be identified?
What is meant by a Highest Cost Plan?
How would you load a very large file in teradata in general?
What are the advantages of teradata?
What is dimensional modeling?
What interface is used to connect to windows based applications?
