Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Select statement question

Re: Select statement question

From: Ralf Zwanziger <goldensurfer_at_gmx.de>
Date: Tue, 18 Sep 2001 09:56:17 GMT
Message-ID: <3ba71a13.100830716@news.fth.sbs.de>


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 Received on Tue Sep 18 2001 - 04:56:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US