We're looking to get all fields for the records that match the criteria.



-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Nick Upson
Sent: Thursday, April 12, 2007 8:49 AM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] data retrieval



you can get the required values by

select col1, col2 from table1
group by col1, col2
having count(*) = 1

or

select distinct col1, col2 from table1

for the other parts of the records like rec# the problem is which one
do you want?

On 12/04/07, Peter Turner <PeterTurner@...
<mailto:PeterTurner%40sunnuclear.com> > wrote:

> Mis-typed what we wanted.....meant we wanted rec #1, #2, #4, #5, #6,

and

> #7 - skipping #3 and #8
>
>
>
> pbt.
>
>
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com

<mailto:firebird-support%40yahoogroups.com>

> [mailto:firebird-support@yahoogroups.com

<mailto:firebird-support%40yahoogroups.com> ] On Behalf Of Alan McDonald

> Sent: Wednesday, April 11, 2007 5:38 PM
> To: firebird-support@yahoogroups.com

<mailto:firebird-support%40yahoogroups.com>

> Subject: RE: [firebird-support] data retrieval
>
>
>
> > hi,
> >
> > have a table with the following conceptual data...
> > rec# col1 col2 ... coln
> > 1 1 d data
> > 2 1 m data
> > 3 1 d data
> > 4 2 d data
> > 5 2 m data
> > 6 3 d data
> > 7 3 m data
> > 8 3 d data
> >
> > trying to come up with a single query that would return unique

records

>
> > where the combination of col1 and col2 are unique. in the example,
> > would want rec #1, #2, #3, #4, #6, and #7.
> >
> > have come up with a couple of multiple query ideas, but was

wondering

> > how to do this in a single query (if possible).
> >
> > TIA,
> >
> > Pete Turner
> > Sun Nuclear Corp.
>
> but #5 is unique too no?
> Alan
> try a view on ditinct col1, col2
> then join the other data to the view
> Alan
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org <http://www.firebirdsql.org> and

click the Resources item

> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com

<http://www.ibphoenix.com>

>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>

[Non-text portions of this message have been removed]