how to delete duplicate records in multi set table without using any tables
Answer Posted / nidhi
make use of Qualify, though it wont delete duplicate..but
also wont show u duplicate as well in answer set.
Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the various indexes in teradata? Why are they preferred?
What is collect statistics?
How to eliminate product joins in a teradata sql query?
Explain the teradata primary index mechanics in detail with a diagram.
What is upsert statement in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is real time and near real time data warehousing?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Can you connect multiload from ab initio?
Define views in teradata with syntax.
What are the commands to make a new table, change a table and remove a table in teradata?
What happens when a node suffers a downfall?
What are default access rights in teradata?
if collect stats but it show low confidence why?