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
- 59978 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
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What are the things to be considered while creating secondary index?
What is spool space?
What happens when a node suffers a downfall?
Can you connect multiload from ab initio?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
In general, how do you optimze any sql in teradata?
what is object level locking ? where do appear this type of locking ?
How many codd's rules are satisfied by teradata database?
What are the frequently used data types in teradata?
what is sysdba and sysdbc ? which has high priority ?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is the command in bteq to check for session settings ?
What are the available primary index types in teradata.
How many types of joins are there in teradata?
