make use of Qualify, though it wont delete duplicate..but also wont show

how to delete duplicate records in multi set table without using any tables

Question Posted / nidhi

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

Please Help Members By Posting Answers For Below Questions

What is the use of having index on table?

962

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1002

How is MLOAD Teradata Server restarted after execution?

1191

Can we collect statistics on table level?

994

What are the various indexes in teradata? How to use them? Why are they preferred?

1012

Highlight the need for Performance Tuning.

1044

Explain the teradata primary index mechanics in detail with a diagram.

922

Explain BYNET.

957

What is database exceptions in teradata?

905

Explain the new features of teradata?

1000

While creating table my dba has fallback or no fallback in his ddl. What is that?

1124

Where is teradata rdbms used?

1047

If a Node is busy what are the steps you can take to avoid ?

2361

What is teradata? Also, list out some of the primary characteristics of teradata.

995

Explain the term 'database' related to relational database management system?

942