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,
Sashi