Use Alias Table1 As A Table1 As B

Select col FRom A where in B ...... where count(Col) > 1



>From: kiran choudhari <[Email Address Removed] [Email Address Removed] Deletion of duplicate records
>Date: Wed, 21 Aug 2002 03:32:45 -0700 (PDT)
>
>
>How to delete duplicate records from a table with one single SQL query.
>I do not want to use temp or another table.
>Thanks
>Kiran
>
>
>
>---------------------------------
>Do You Yahoo!?
>HotJobs, a Yahoo! service - Search Thousands of New Jobs




_________________________________________________________________
Rejoignez MSN Hotmail, le plus important service de messagerie
http://www.hotmail.com/fr

MS Sql Server LazyDBA home page