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
- 59046 Views
- I also Faced
- E-Mail Answers
Answer Posted / manny
One need have atleast a unique column such as timestamp col
(and assumption is to keep lowest tmpstmp) OR some key col
say IPID (again keep lowest value)..
One determined - Have a nested Select on all rows (except
that key col) with group by rest of the columns + having
count(*) > 0 + aggreate MIN(key_col).
Now said that, have another outer SEL on all columsn &
do a inner join with above nested Sel .. WHERE outer
key_col <> MIN value of nested SEL..
See if it works..
| Is This Answer Correct ? | 5 Yes | 16 No |
Post New Answer View All Answers
What are the updated features of teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Highlight the need for Performance Tuning.
How can bottlenecks be identified?
How to identify ppi columns?
How can you track login parameters of users in teradata?
What's the difference between timestamp (0) and timestamp (6)?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What are the functions of a teradata dba?
What is meant by a Virtual Disk?
Did you write stored procedures in teradata?
Differentiate database data and data warehouse data?
What is the syntax for case when statement?
What are the different table types supported by teradata?
