Archives of the TeradataForum

Message Posted: Tue, 11 Jan 2005 @ 12:10:16 GMT

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

Try :

     Select
         location
        ,Barcode
        ,SOH
        ,RANK() OVER (PARTITION BY location
                      ORDER BY Barcode, SOH) as 'RankValue
     From
       tablename
     Where soh < 0
     QUALIFY RankValue <=N
     ;

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