Skip to main content
johng58900177
johng58900177
Known Participant
Jul 3, 2020 2:35 PM UTC
Question

Output same number

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 is closed to new replies. Start a new post to keep the conversation going.

    1 reply

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    Jul 4, 2020 1:57 PM UTC

    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
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices