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
- 59939 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 are different table types used in teradata?
What are the main components of teradata system?
What are the different functions included in the server software?
What is the use of having index on table?
what is object level locking ? where do appear this type of locking ?
What are the uses of bynets in multi-node systems?
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
Explain the meaning of Amp?
what are the uses of fact table and dimension table in banking project?
What is a dimension table?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
List out teradata data types?
What is bteq script in teradata?
What is teradata? What are some primary characteristics of teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
