Re: Demo: Db For Dummies

jcelko212_at_earthlink.net (--CELKO--) wrote:

>>> Above type queries can only be resolved via code/API at this time.
>The psuedo code below solves similar but simpler case: <<
>
>Why would I want to write proceudral code for this things?
>
>>> "Person with uniqie hair color? That is, a person with a hair color
>such that there doesn't exist anybody else with this color" <<

     I have dark brown hair, and I also have grey hair. Then, there are shades. I smell a bad model.

>Or the hair occurs once in the population. Rewording makes life much
>easier.
>
>SELECT hair_color, MAX(person_id)
> FROM Population
> GROUP BY hair_color
>HAVING COUNT (*) = 1;
>
>And I agree with another comment; I do not see the point of these code
>postings.

     Since I have dark brown hair and grey hair, what is my hair_color?

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:

     I have preferences.
     You have biases.
     He/She has prejudices.