Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> impact of running MAX() on a varchar field ?

impact of running MAX() on a varchar field ?

From: Jack <jack_posemsky_at_yahoo.com>
Date: 8 Feb 2004 07:46:40 -0800
Message-ID: <209b7e58.0402080746.6fa6c75a@posting.google.com> 





Greetings,



I am de-duping some rows (group by custID) and placing MAX() on all
other fields which are varchar.  Does anyone know what the effect of
doing MAX() on varchar fields is ?  Will it randomly select the MAX
value of any of these


fields across duplicate cust IDs (mixing fields from different rows),
or will it randomly select a custID and retain that row's attributes
with integrity?


Thanks,



Jack
Received on Sun Feb 08 2004 - 09:46:40 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US