Limit query output to a single record based on combination of fields
Date: Mon, 12 May 2008 07:43:11 -0700 (PDT)
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
I'm not sure about how to do this.
Can someone help out?
Sashi Received on Mon May 12 2008 - 09:43:11 CDT