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
- 59224 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
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?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
List out all forms of LOCKS that are available in Teradata.
What are tpump utility limitations?
Explain the term 'row' related to relational database management system?
How many types of joins are there in teradata?
How does hashing happens 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 ?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What are the joins in teradata and how many types of joins are there in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Explain teradata utilities?
What is teradata? What are some primary characteristics of teradata?
