Archives of the TeradataForum
Message Posted: Thu, 25 Oct 2001 @ 19:31:45 GMT
Change the where to having. Changing the order by to 2 desc gives you the col1's with the most duplicates first. If that is of value. Ie.
select col1 , count(seq_nbr)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|