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 the use of having index on table?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
How is MLOAD Teradata Server restarted after execution?
Can we collect statistics on table level?
What are the various indexes in teradata? How to use them? Why are they preferred?
Highlight the need for Performance Tuning.
Explain the teradata primary index mechanics in detail with a diagram.
Explain BYNET.
What is database exceptions in teradata?
Explain the new features of teradata?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Where is teradata rdbms used?
If a Node is busy what are the steps you can take to avoid ?
What is teradata? Also, list out some of the primary characteristics of teradata.
Explain the term 'database' related to relational database management system?