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@...> 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@yahoogroups.com] On Behalf Of Alan McDonald
> Sent: Wednesday, April 11, 2007 5:38 PM
> To: firebird-support@yahoogroups.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 and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>