Re: Listing of non distinct rows

From: Tom Best <tombest_at_firstusa.com>
Date: 19 Jul 2001 14:33:01 -0700
Message-ID: <99ab87b0.0107191333.623adc1c@posting.google.com>

Scott:

This would do it:

select a, b, c, count(1) from table_a

group by a, b, c
having count(1) > 1

Hope this helps.

Tom Best

scott.nutter_at_pmcsystems.com (Scott Nutter) wrote in message news:<76e6d6e.0107190712.76f49403_at_posting.google.com>...
> I have a table that has a unique constraint on 4 coulmns. I want to
> change it to use only 3 columns as a unique constraint, however I want
> a listing of the rows that will now be duplicates. Any ideas as to
> how to get a listing of rows that are not distinct?
>
> Thanks
Received on Thu Jul 19 2001 - 16:33:01 CDT