Answer Posted / tdguy
Adding to the above,if enough spool space is available, 1.
create a volatile table with the same structure 2. insert
into volatile table
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
3. delete from target table and insert from volatile table.
All the above steps should be done with the same session.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the functions of a teradata dba?
What are the different table types that are supported by teradata?
Explain BYNET.
Explain and compare pros and cons of snow flake schemas?
why use references rather than pointers in the public api, particularly for arguments which are modified?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
Explain the term 'database' related to relational database management system?
Why teradata is used?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
How is MLOAD Teradata Server restarted after execution?
What is the use of having index on table?
What are the different table types supported by teradata?
What is a three-tier data warehouse?
How to find duplicates in a table?
Can we collect statistics on table level?
