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

Home -> Community -> Usenet -> c.d.o.tools -> Re: select disinct special

Re: select disinct special

From: Jacek Kobusiński <jkobusinski_at_cs.put.poznan.pl>
Date: 2000/08/04
Message-ID: <398ADFFB.72786C1D@cs.put.poznan.pl>#1/1

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

Original text of this message

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