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

Output same number

New Here ,
Jul 03, 2020 Jul 03, 2020

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? 

152
Translate
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
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

Translate
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