Archives of the TeradataForum
Message Posted: Thu, 25 Oct 2001 @ 19:42:22 GMT
Need a little more input.
If a sequence number is being used, what condition causes it to be used more than once?
If a seq nbr is being used to create a unique key, it indicates that col1 is not unique. Do the dupe seq nbrs have the same col1 value?
If you're looking for dupe seq nbrs only use:
Select seq_nbr, count(*)
If you're looking for dupe col1/seq nbr combos use:
Select col1, seq_nbr, count(*)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|