Interview Questions Answers in Teradata

petko

{ City }
< Country > india
* Profession *
User No # 40538

Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 10
Users Marked my Answers as Wrong # 12

Questions / { petko }

Questions Answers Category Views Company eMail

Answers / { petko }

Question { 59069 }

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

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