Archives of the TeradataForum

Message Posted: Tue, 15 Aug 2006 @ 23:13:12 GMT

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

I choose this option:

     select
     cd_producto,
     cd_equipo_adsl,
     count(cd_producto) over(partition by cd_producto)
     from
     productos
     qualify row_number() over(partition by cd_producto order by
     cd_equipo_adsl desc) = 1;

Thanks anyway.

Castelli, Emanuel Alejandro
Desarrollo DataWarehouse - IBM Argentina

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