Output same number

New Here ,
Jul 03, 2020 Jul 03, 2020

Copy link to clipboard

Copied

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? 

Views

56

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Jul 04, 2020 Jul 04, 2020

Copy link to clipboard

Copied

LATEST

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines