Archives of the TeradataForum
Message Posted: Fri, 28 May 2010 @ 09:52:34 GMT
I am using the ROW_NUMBER function in two sub queries and doing an INNER JOIN however it is giving the different count each time. Any help would be definitely appreciated -
First Sub Query using this function
ROW_NUMBER () OVER (ORDER BY CUST_ID, CUST_ACTN_DT asc, NEW_CUST_ACT_DT ASC) AS ALL_ROWNUM
And in the second sub query I am using the MIN of the above function.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|