Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / yuvaevergreen
yes...the above option can be used if access has been
provided to create set tables.If not, partition by clause
can be used.
1. create table2 as table1 with no data;
2. insert into table2
sel column1,column2,,,columnn from table1
group by 1,2
qualify row_number() over (partition by
column1,column2,,,columnn order by
column1,column2,,,columnn desc) =1
where table1 is with duplicates and table2 would be target
table.
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
When tpump is used instead of multiload?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Difference between multiload and tpump?
How do you verify a complicated sql?
What are the main components of teradata system?
Is multi insert ansi standard?
What is database exceptions in teradata?
What is a three-tier data warehouse?
How can bottlenecks be identified?
What are the 5 phases in a multiload utility?
what are the uses of fact table and dimension table in banking project?
What are the frequently used data types in teradata?
Explain BYNET.
How to identify ppi columns?
How do you see a ddl for an existing table?
