Archives of the TeradataForum

Message Posted: Thu, 25 Oct 2001 @ 19:49:15 GMT

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

You should probably use a derived table to do this.....something like the following might do the trick:

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

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