Archives of the TeradataForum

Message Posted: Thu, 02 Dec 2004 @ 22:48:06 GMT

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

Hi:

Not sure if you are after the same info, but try this:

     SELECT        country, state, RANK(county)
     FROM        (
     SELECT        country, state, county
     FROM        region
     ) as a1
     order by 1,2,3
     QUALIFY        RANK(county) <=50;

Thanks & Regards,

Pete

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