SQL compare question.. non-distincts

[Damnit Spock!]

Hi, Im wondering is CF has an easy way of doing this, or if there is a way
using SQL:

I'm finding duplicated rows in the DB (SQL*SVR) and need to schedule a script
that runs and compares the contents of the first 7 or 8 columes per row to
determine if there is a duplicate item. The determining factors that identify
a unique item are these columns. Something like "Search through the db and
look for these NON-DISTINCT values for the columns in question"? (where all 7
column values are the same)

Many thanks

[jonwrob]

What do you want to know about them?

SELECT column1, ... column8, count(*)
FROM table
GROUP BY column1, ... column8
HAVING count(*) > 1

will show you the count of rows for each of the 8 values that appear more than
once.

A unique key on those 7 or 8 columns will prevent duplicates from being
entered, but any duplicates will have to be removed before you can apply the
constraint.

JR