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
- 59025 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
Explain teradata utilities. What is multiload, fast load, tpump?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
How to find duplicates in a table?
What are the enhanced features in teradata v2r5 and v2r6?
What is the use of virtual processor connectivity in teradata?
What is node? How many nodes and amps used in your previous project?
Is multi insert ansi standard?
What is the purpose of joins in teradata?
What do you mean by teradata sql assistant?
What is bteq utility in teradata?
What is a node in teradata?
How to view every column and the columns contained in indexes in teradata?
What is the difference between teradata and basic rdbms?
What is partitioned primary index (ppi)?
Explain some differences between mpp and smp?
