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.
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
How to identify ppi columns?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
How to Extract data from multiple legacy systems?
What do you mean by teradata intellicloud?
what is object level locking ? where do appear this type of locking ?
how do you manage the production space. what are the proactive methods you can take ?
What tools would you use for that?
What are the different table types supported by teradata?
What are the joins in teradata and how many types of joins are there in teradata?
Why do you get spool space errors? How do trouble-shoot them?
How is the teradata different from oracle?
How will you solve the problem that occurs during update?
what are the uses of fact table and dimension table in banking project?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
How can we check the version of Teradata that we are using currently?