Archives of the TeradataForum

Message Posted: Tue, 15 Aug 2006 @ 10:40:30 GMT

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

I replied a little too quick on this suggestion. After actually have time to read it, the OLAP functions are not allowed in a WHERE.

do this:

     >   Where
     >                    SRC_DW_CD = :src_dw_cd_in
     >                    and clm_disp_cd = 'READJ'
     >   Qualify count(*) OVER (PARTITION BY SRC_DW_CD,
     > CLM_SRC_SYS_CD, CLM_NBR, CLM_LN_NBR, MBR_KEY,CLM_LN_ADJMT_NBR) >1

Sorry about my haste in my first reply. If you tried the original, an error would have told you that these functions require a QUALIFY.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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