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
- 55604 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 a level of granularity of a fact table?
What are the advantages of teradata?
What is basic teradata query language?
What are teradata utilities?
What is meant by a node?
What is dimensional modeling?
Define views in teradata with general syntax.
Describe primary index in teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What are the different table types supported by teradata?
What is logical data model?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
How to Extract data from multiple legacy systems?
What do you mean by ttu in teradata?
