Skip to main content
johng58900177
johng58900177
Known Participant
July 3, 2020
Question

Output same number

  • July 3, 2020
  • 1 reply
  • 185 views

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? 

    This topic has been closed for replies.

    1 reply

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    July 4, 2020

    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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices