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
Can you connect multiload from ab initio?
What is database exceptions in teradata?
Is multi insert ansi standard?
What is the maximum number of dml can be coded in a multiload script?
How would you load a very large file in teradata in general?
What are the different design perspectives used in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is the difference between union and union all in teradata?
What are aggregate tables? How do you design them using teradata?
What is bteq utility in teradata?
What are the steps involved after the disk manager passes the request?
Highlight the differences between Primary Key and Primary Index.
How many tables can you join in v2r5?
What is the difference between global temporary tables and volatile temporary tables?
Explain amp in teradata?