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 -> select disinct special

select disinct special

From: Stefan <stefanp_at_mediaaktiv.de>
Date: 2000/08/04
Message-ID: <398ACA9D.322D291D@mediaaktiv.de>#1/1

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