Multiple values

From: James Alger <james.alger_at_bt.com>
Date: Mon, 1 Oct 2001 11:37:26 +0100
Message-ID: <9p9h7j$amo$1@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 - 05:37:26 CDT