Cheers!
"Marc" <langkamp_at_mailcity.com> wrote in message
news:3bb8563f$1_at_gaspra.oss.akzonobel.nl...
> SELECT distinct TO_CHAR(OBJECT_DBID) OB_DBID
> FROM CFG_APP_OPTION
> ORDER BY OB_DBID ASC
>
>
> "James Alger" <james.alger_at_bt.com> wrote in message
> news:9p9h7j$amo$1_at_pheidippides.axion.bt.co.uk...
> > Could anybody tell me if there is a way of ensuring that each item of
data
> > is displayed only once in an SQL querie.
> >
> > I currently have the following querie:
> > SELECT TO_CHAR(OBJECT_DBID) OB_DBID
> > FROM CFG_APP_OPTION
> > ORDER BY OB_DBID ASC
> >
> > However, when I execute it I get the following (Row is just for
reference)
> > (Row) VALUE
> > (1) 101
> > (2) 101
> > (3) 101
> > (4) 102
> > (5) 102
> > (6) 103
> > (7) 104
> > (8) 104
> >
> > What I need it to do is :
> > (Row) VALUE
> > (1) 101
> > (2) 102
> > (3) 103
> > (4) 104
> >
> > Does Anyone have any ideas?
> >
> >
>
>
Received on Mon Oct 01 2001 - 07:09:58 CDT
