Archives of the TeradataForum

Message Posted: Thu, 22 Mar 2012 @ 21:36:35 GMT

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

Sorry! Try again...just replace what's in "[]" with your table and field. It'll work. Let me know.

     SELECT TOP 255 a.[FIELD_NAME], COUNT(*)
     FROM
     (SELECT TOP 500000 *
      FROM  [TABLE_NAME])  a
      GROUP BY 1

Hui Zhong
MBA | Manager, MIS Reporting | Credit Adjudication & Collections | Royal
Bank of Canada

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