Interested to Buy Any Domain ? << Click Here >> for more details...
Write a single SQL to delete duplicate records from the a
single table based on a column value. I need only Unique
records at the end of the Query.
- 13 Answers
- 59949 Views
- I also Faced
- E-Mail Answers
Answer Posted / bharath
guys rowid concept is discontinued in teradata as far as my
knowledge goes, we can always use below sql ...
INSERT INTO nodupes_table ( all_columns )
SELECT all_columns
FROM dupes_table
QUALIFY ...
where the QUALIFY ... can be (depending on your version):
/* V2R5 syntax */
QUALIFY ROW_NUMBER() OVER (PARTITION BY all_columns
ORDER BY all_columns) = 1
/* or V2R4 and higher equivalent functionality */
GROUP BY all_columns
QUALIFY CSUM(1, all_columns ) = 1
/* or, alternative OLAP SUM V2R4 and higher syntax */
QUALIFY SUM(1) OVER (PARTITION BY all_columns ORDER BY
all_columns ROWS
UNBOUNDED PRECEDING ) = 1
I do think an insert-select into a set table would be a
cleaner process (don't know about runtime, though):
INSERT INTO nodupes_set_table ( all_columns )
SELECT all_columns
FROM dupes_table;
refer to teradata forum for more info
| Is This Answer Correct ? | 17 Yes | 5 No |
Post New Answer View All Answers
Can you connect multiload from ab initio?
What are the various indexes in teradata? How to use them? Why are they preferred?
How to identify ppi columns?
What type of indexing mechanism do we need to use for a typical data warehouse?
What do you mean by teradata intelliflex?
What is a node in teradata? Explain
How do you determine the number of sessions?
What are the newly developed features of Teradata?
Steps to create a data model?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is meant by a Channel Driver?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What exactly do you know about catching in teradata?
What is dimensional modeling?
What is the opening step in basic teradata query script?
