Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> select disinct special
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