Home Page for the TeradataForum
 
 

 
from < table > group by 1,2,...,n having count (*) > 1;

-dave.clark





Archives of the TeradataForum





Message Posted: Wed, 05 May 2004 @ 18:57:29 GMT





     
  <Prev Next>   <<First <Prev Next> Last>>  




Subj:   Re: Deleting Duplicates with a single DELETE statement
 
From:   Clark, Dave



To find all of the duplicate rows in a particular multiset table use the query below:

    ----------------------------------------------------------

    select < col 1 >, < col 2 >, ... , 
     
  <Prev Next>   <<First <Prev Next> Last>>  
 

Recent Threads

Attachments

Library

Quick Reference

Useful Links

Rules of Conduct

FAQs

Join the Forum

 

Archives

Sample Index

2008  2003
2007  2002
2006  2001
2005  2000
2004  1999 

 

2004 Indexes

Jan  Jul
Feb  Aug
Mar  Sep
Apr  Oct
May  Nov
Jun  Dec


 
 
 

 
 
           
 
  Top Home Join Privacy Feedback  
    Copyright for the TeradataForum (TDATA-L), Manta BlueSky  Last Modified: 30 Jun 2008