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 is a clique?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What do you mean by caching in teradata?
What is a three-tier data warehouse?
What are the different methods ot loading a dimension table? A fact table etc?
What is the use of teradata system software?
What are the available primary index types?
Why teradata is used?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Explain the term 'database' related to relational database management system?
List out some of the primary characteristics of teradata.
What do you mean by fastexport in teradata?
What is the primary index in teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
What does Amp contain and what are all the operations that it performs?