Re: Simple SQL - GROUP BY

Dear Filip:

If you don't matter the person_id I think that your solution is ok.

Best Regards
Joan

Filip Hanik escribió en mensaje ...
>Hi,
>
>I have, ever since I learned SQL, been kind of confused by the GROUP BY
>clause.
>I have successfully used it for computing values.
>
>But here's my problem,
>I want to retrieve two columns out of a table PERSON_ID, COMPANY_ID
>but I'm only interested in retrieving on person per company.
>
>TABLE tblEmployees (
> PERSON_ID INTEGER NOT NULL,
> COMPANY_ID INTEGER NOT NULL
>)
>
>
>So I would like to group by COMPANY_ID but the compiler doesn't let me
>retrieve the PERSON_ID.
>
>If I put a MAX around PERSON_ID will I get a correct person_id like this?
>SELECT MAX(PERSON_ID), COMPANY_ID FROM tblEmployees GROUP BY COMPANY_ID;
>
>thanks
>
>Filip
>fhanik_at_digitalworkforce.net
>
>
>
Received on Fri Jul 02 1999 - 07:07:51 CDT