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
- 59950 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankal
Hi guys,
As per my knowledge i am expecting the following ans.
1.If u want delete duplicates at runtime means
output time it shows unique values but not delete
from table.
The following query.
=> Select [all columns] from tablename group by [all columns];
(OR)
2.If u want delete duplicate values from total table.
The following query.
The table having duplicates means it is multiset table so,
=> create set table nodup_table as dup_table with data;
If u want the table name as same do like this.
=> Next just drop table dup_table;
=> Finally rename table nodup_table to dup_table;
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What is meant by Teradata Gateway?
Write a program to show the parser component used in teradata?
What are the 5 phases in a multiload utility?
What is the difference between fastload and multiload? Which one is faster?
What is meant by a Parsing Engine?
What are the updated features of teradata?
Why is the case expression used in teradata?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What is upsert statement in teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Explain the most common data types used in teradata?
Explain and compare pros and cons of start schemas?
What do you mean by fastexport in teradata?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Explain BYNET.
