Archives of the TeradataForum

Message Posted: Thu, 25 Oct 2001 @ 19:53:01 GMT

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

Sorry...forgot to include the aggregation clause.....{;->

select A.col1,
       A.colfrequency
  from (select distinct(col1) as col1,
               count(col2) as colfrequency
          from table
      group by col1) A
 where A.colfrequency > 1 ;

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