Answer Posted / tdguy

creating a new table would be the best option, if all the
field values are same, as far as i know.
CREATE NEW_TABLE AS OLD_TABLE WITH NO DATA;
INSERT INTO NEW_TABLE
SELECT COLUMN1, COLUMN2,COLUMN3 FROM OLD_TABLE
QUALIFY ROW_NUMBER() OVER
(PARTITION BY COLUMN1, COLUMN2,COLUMN3
ORDER BY COLUMN1, COLUMN2,COLUMN3 ASC ) = 1;
DROP TABLE OLD_TABLE;
RENAME NEW_TABLE TO OLD_TABLE;

What is the difference between teradata and oracle?

1019

---

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2170

---

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2412

---

What is database exceptions in teradata?

944

---

Highlight the need for Performance Tuning.

1103

---

Describe the between keyword in teradata?

1030

---

What is collect statistics?

994

---

What is the meaning of Caching in Teradata?

1132

---

Describe primary index in teradata?

998

---

Explain the advantages of partitioned primary index in a query?

1020

---

Write a program to show the parser component used in teradata?

969

---

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2200

---

How is MLOAD Client System restarted after execution?

1139

---

Highlight the limitations of TPUMP Utility.

1111

---

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1095

---