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

by Sashi <smalladi@[EMAIL PROTECTED] > May 12, 2008 at 07:43 AM

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****

5 Posts in Topic:

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

Sashi <smalladi@[EMAIL

2008-05-12 07:43:11

Re: Limit query output to a single record based on combination o

Urs Metzger <urs@[EMAI

2008-05-12 16:55:12

Re: Limit query output to a single record based on combination o

Sashi <smalladi@[EMAIL

2008-05-12 08:13:34

Re: Limit query output to a single record based on combination o

Urs Metzger <urs@[EMAI