Sa**** schrieb:
> Hi all,
>
> I have a query as follows:
>
> Select building, floor from T1
>
> I would like to limit the output where the building, floor combination
> is present only once in the output.
>
> For example, if the output is
>
> blgdA, 2
> bldgA, 3
> bldgA, 3
> bldgB, 1
> bldgB, 2
> bldgB, 2
>
> I would like to filter it so that the output is only
> blgdA, 2
> bldgB, 1
>
> I'm not sure about how to do this.
>
> Can someone help out?
> Thanks,
> Sa****
Search the docs for GROUP BY and HAVING.
htht,
Urs Metzger
|
