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.
Answer Posted / petko petkov
The following example shows how to create table and insert
data without duplicate rows from existing table:
CREATE TABLE NODUPS AS
(
SELECT * FROM Departments
UNION
SELECT * FROM Departments
)
WITH DATA;
Is This Answer Correct ? | 10 Yes | 12 No |
Post New Answer View All Answers
What are the different design perspectives used in teradata?
What exactly do you know about catching in teradata?
What can be achieved by using the teradata rdbms?
What is a level of granularity of a fact table?
What is meant by a Virtual Disk?
What do you mean by fastexport in teradata?
any one answer me how they can analyzing the project using data ware housing?
What is a node in teradata? Explain
Explain the term 'database' related to relational database management system?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Explain teradata architecture?
What are the functions of a Parser?
What is the difference between fastload and multiload?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What are the various indexes in teradata?