MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » December 2012

Re: Interesting SQL Question - Flatten Multiple Records into One Record



fixed

On 03 Dec 2012 10:53, Richard Schoen wrote:
I don't know if I stated it, but my assumption would be to only use
this technique for unique fields.


If I understand correctly... Care must still be taken, as I alluded. The assumption that the predicate will be used only on a UNIQUE protected column may be irrelevant, given any failure to ensure the situation that I had presented will never transpire. That is to suggest... The example I gave does have unique\distinct values. A LIKE [or equivalent LOCATE] predicate by itself, can not guarantee just one matching result amongst those distinct values; instead, either an equivalence [equal] predicate must be used, or some constraints on the data would be required to prevent those other predicates from ever yielding more than one matching row.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact