Archives of the TeradataForum

Message Posted: Fri, 12 Aug 2005 @ 10:00:34 GMT

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

<-- Anonymously Posted: Friday, August 12, 2005 05:55 -->

HI

use this

     select   trim(keyval), min(applied), max(applied)
     from anomy
     group by 1 ;

this will give u the desired result .you are getting the multiple value of keyval because the in some occurrence of keyval some wide characters are attached . i.e. 'A' and 'A ' .it look same but they are not.

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