Archives of the TeradataForum

Message Posted: Fri, 28 May 2010 @ 09:52:34 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

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.

Thanks,

Syed

	<Prev	Next>		<<First	<Prev	Next>	Last>>