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

From: Sashi <>
Date: Mon, 12 May 2008 07:43:11 -0700 (PDT)
Message-ID: <>

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

Original text of this message