| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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
 |
 |