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
- 59608 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
Describe the between keyword in teradata?
Which is faster fastload or multiload?
What is TPD?
What does Amp contain and what are all the operations that it performs?
How can we check the version of Teradata that we are using currently?
What is the difference between global temporary tables and volatile temporary tables?
What is the command in bteq to check for session settings ?
Where is teradata rdbms used?
What is the use of fallback?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is the difference between teradata and basic rdbms?
What is logical data model?
Discuss the advantages of using partitioned primary index in a query?
When tpump is used instead of multiload?
How do you set the session mode parameters in bteq?
