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
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
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?
What are the enhanced features in teradata v2r5 and v2r6?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is the purpose of upsert command?
Difference between stored procedure and macro?
How to load specific no.of records using bteq, or fastload,or multiload
If a Node is busy what are the steps you can take to avoid ?
what are the uses of fact table and dimension table in banking project?
What is the use of stored procedures in teradata?
Explain and compare pros and cons of start schemas?
What are the commands to make a new table, change a table and remove a table in teradata?
What is the function of parser component in teradata?
What are the functions involved in shared information architecture?
What is the difference between union and union all in teradata?
