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
- 59582 Views
- I also Faced
- E-Mail Answers
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 bteq script in teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is bteq utility in teradata?
What is the difference between teradata and basic rdbms?
What are the components provided on node?
What is the difference between union and union all in teradata?
What is smp and mpp platforms?
Define views in teradata with syntax.
Can you connect multiload from ab initio?
What are the scenarios in which full table scans occurs?
How to find duplicates in a table?
How many sessions of MAX is PE capable of handling at a particular time?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
How do you verify a complicated sql?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
