Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 31 May 2010 @ 10:33:10 GMT


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


Subj:   Re: ROW_NUMBER()OVER
 
From:   anusha.srichander

Hi Syed,

Could you please use Rank function instead of ROW_NUMBER and test it out? Because, the ROW_NUMBER function assigns row number at random every time due to the duplicates, where as the RANK function will always assign the same rank to the least values. So your record count will always be the same. But I'm not sure whether it satisfies your requirement.


Regards,

Anusha



     
  <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: 23 Jun 2019