[thelist] Finding NON-unique values in MS SQL
Anthony Baratta
Anthony at Baratta.com
Wed Jul 3 17:20:01 CDT 2002
At 03:10 PM 7/3/2002, Joel Canfield wrote:
>Wouldn't that just tell me if ID appeared in one of the other columns? I
>need to know if any values are repeated in the IDF column, then I need to
>know if any values are repeated in the IDT column.
If you are just interested in "repeats" in a single column this should work...
select Count(IDF), IDF from TableName
where Count(IDF) > 1
group by IDF
--
Anthony Baratta
President
Keyboard Jockeys
"Conformity is the refuge of the unimaginative."
More information about the thelist
mailing list