Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
Let us consider table ‘B’ containing duplicates.
Create a empty table ‘A’ with set option and send the data
from table ‘B’ to table ‘A ‘so that only unique records will
be inserted. Now drop table ’B’ and rename table ‘A’ with
table ‘B’.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What tools would you use for that?
What is the multi-insert?
Is multi insert ansi standard?
What is inner join and outer join?
What is the basic syntax for teradata select statement?
What are the uses of bynets in multi-node systems?
What are the string manipulation operators and functions associated with teradata?
Why do you get spool space errors? How do trouble-shoot them?
How would you load a very large file in teradata in general?
What is teradata and why it is used?
Explain the term 'foreign key' related to relational database management system?
What is a clique?
What are the main components of teradata system?
Explain the term 'tables' related to relational database management system?
While creating table my dba has fallback or no fallback in his ddl. What is that?
