Highlighted

Output same number

New Here ,
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

26

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

Output same number

New Here ,
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

27

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
Jul 03, 2020 0
BKBK LATEST
Adobe Community Professional ,
Jul 04, 2020

Copy link to clipboard

Copied

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
Reply
Loading...
Jul 04, 2020 0