Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   ROW_NUMBER()OVER
 
From:   Ahmad, Syed Rehan

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016