Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: select disinct special
Try with function substr
ex.
select distinct subst(city_name,1,1) from city_table;
Kobus
Stefan wrote:
> 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
![]() |
![]() |