Archives of the TeradataForum
Message Posted: Thu, 16 Aug 2007 @ 15:21:09 GMT
I'm sorry there is a mistake on this. It should be > 1 not > 0.
Select col1, col2, abc, ghj, abc, ghj from table A group by 1,2,3,4,5,6 having count(*) > 1
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|