• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

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

104

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
Community Expert ,
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

Votes

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
Resources
Documentation