Copy link to clipboard
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?
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 distinctOrderNrsFROM tableName