0

Is there a syntax for 'select distinct'?

If I have rows of transaction date and I want to extract distinct (each member 1 time) list from a column, is there a "select distinct" syntax like there is in SQL?

2 replies

null
    • Fred
    • 3 yrs ago
    • Reported - view

    You can use the unique function:

     

    unique(field name)

    unique(variable)

     

    let x := select Invoices

    count(unique(x.CustomerID))

    • Chapel_of_Praise
    • 3 yrs ago
    • Reported - view

    Thank you.

Login to reply

Content aside

Categories

View all topics
  • 3 yrs agoLast active
  • 2Replies
  • 623Views