| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: select disinct special
Try this: select distinct substr(filed_name, 1, 1) from ...
Stefan a écrit:
> Hi,
>
> got table like
>
> CITY
>
> Dallas
> Detroit
> ...
> New York
> Nagasaki
> ...
> Washington
> ...
>
> how to get only one city of each letter ?
>
> i just wanna get back
>
> D ( or any city with starting 'D' , but only ONE city)
> N ...
> W ...
>
> any ideas out there ?
> thanx
Received on Fri Aug 04 2000 - 00:00:00 CDT
 |
 |