[thelist] MS SQL 2000

[Casey Crookston]

[snip]
Is it possible to run a query that would return all rows that are exact
duplicates except for the unique identifier?
[/snip]
 
Yes, it is possible.


~~~~~~~

Smarty pants.  Ok... how do you do it?

;-)

Thanks!




























Start here....

SELECT COUNT(`foo`) AS `duplicate` FROM `bar` GROUP BY `foo` HAVING
`duplicate` > 1 
-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt !