Output same number

[johng58900177]

I have a query that is going to return multiple of the same number (order numbers with add-ons).  How can I query the db and only output 1 of the those duplicate numbers? 

[BKBK]

Could you let us see the query you're currently using?

In any case, to get the list of distinct order numbers:

SELECT DISTINCT(orderNumbers) AS distinctOrderNrs
FROM tableName