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
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Highlight the limitations of TPUMP Utility.
What is the function of parser component in teradata?
What is bteq script in teradata?
What is the meaning of Caching in Teradata?
What are different table types used in teradata?
How do you verify a complicated sql?
How many types of joins are there in teradata?
How many tables can you join in v2r5?
What are the functions performed by bynet?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain the types of join supports by teradata?
In BTEQ, how are the session-mode parameters being set?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the things to be considered while creating secondary index?
