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 is inner join and outer join?
Why managing the data is important?
Is multi insert ansi standard?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Why is the case expression used in teradata?
What is spool space?
What are different table types used in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What are the different functions included in the server software?
any one answer me how they can analyzing the project using data ware housing?
Explain the term 'tables' related to relational database management system?
What is teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
What is upsert statement in teradata?
How many sessions of MAX is PE capable of handling at a particular time?