Limit query output to a single record based on combination of fields

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 Received on Mon May 12 2008 - 09:43:11 CDT