What is max doing across fields in a de-duplication ?

From: Jack <jack_posemsky_at_yahoo.com>
Date: 8 Feb 2004 07:01:22 -0800
Message-ID: <209b7e58.0402080701.31e92c77@posting.google.com>

Greetings folks,

Just curious if anyone knows what the following would produce: SELECT
    MAX( ECP_SUPPORT_DED_EMAIL.CD_TYP_CMPGN) CD_TYP_CMPGN,     MAX(ECP_SUPPORT_DED_EMAIL.CELL_ID) CELL_ID,     ECP_SUPPORT_DED_EMAIL.CLIC_CUST_ID CUSTID,     MAX( ECP_SUPPORT_DED_EMAIL.ADDRESS) CONTACTED_PARTYID,     MAX( ECP_SUPPORT_DED_EMAIL.CONTACTED_PARTY_ID_TYPE ) FROM
    ECP_SUPPORT_DED_EMAIL
    group by CUSTID

For a given CUSTID, and assuming all fields are character and there are duplicates, will it randomly select the MAX value of any of these fields across duplicates, or will it randomly select a custID and retain that row's attributes with integrity?

thanks!
Jack Received on Sun Feb 08 2004 - 09:01:22 CST