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
Can you fastexport a field, which is primary key by putting equality on that key?
Explain the term 'primary key' related to relational database management system?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is teradata and why it is used?
What are the available join types in teradata?
What are the uses of bynets in multi-node systems?
What do high confidence, low confidence and no confidence mean in explain plan?
What are the main components of teradata system?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What do you mean by teradata sql assistant?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
How to find duplicates in a table?
What is a sparse index?
Which is faster fastload or multiload?
What are the different design perspectives used in teradata?