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 default access rights in teradata? What explicit right can be given to a user?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Did you write stored procedures in teradata?
How does hashing happens in teradata?
Explain vproc in teradata?
What do you mean by tpt in teradata?
What are the functions performed by bynet?
What are the different methods ot loading a dimension table? A fact table etc?
what are the day to day activities of teradata DBA ?
How do you see a ddl for an existing table?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What is the maximum number of dml can be coded in a multiload script?
If a Node is busy what are the steps you can take to avoid ?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is basic teradata query language?