Re: Select statement question

From: Tony <tony1979_at_hotmail.com>
Date: 19 Sep 2001 01:36:38 -0700
Message-ID: <d458d67.0109190036.141eccf4@posting.google.com>

> On 18 Sep 2001 02:48:49 -0700, tony1979_at_hotmail.com (Tony) wrote:
>
> >SELECT Id, Site, Equipment FROM table1 order by Id asc;
> >
> >Should only return row 1 and 3 ( or 2 and 3 ).
> >
> >Is this possible?
>
> yes. Try select distinct:
> SELECT DISTINCT Id, Site, Equipment FROM table1 order by Id asc;
>
> Bye,
> Ralf

What if I need Id and Site to be unique, but not Equipment. Is this possible? ( The select statement must be pretty fast ).

Kind regards,

Tony Lee, UK Received on Wed Sep 19 2001 - 03:36:38 CDT