Archives of the TeradataForum

Message Posted: Thu, 27 Apr 2006 @ 11:55:53 GMT

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

Vijay,

You can use Row_Number which is an OLAP function in V2R5

If you looking for various products and would like the 2nd and 3rd values for each product

     Select Product, Sales_Am
     >From SalesProd_Table
     Qualify Row_Number () Over (Partition by Product Order by Sales_AM Desc)
     in (2,3)

Hope this Helps.

HB
Datawarehouse Analyst
TNT Express ICS

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