Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Select statement question
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
![]() |
![]() |