PxPlus User Forum

Twitter Twitter Twitter

Author Topic: count distinct not working  (Read 213 times)

Thomas Bock

  • Diamond Member
  • *****
  • Posts: 180
    • View Profile
count distinct not working
« on: May 22, 2024, 06:57:37 AM »
I receive an error 15 with
Code: [Select]
select count(distinct columnName) from table
msg(-1)=37000: [PxPlus][SQL ODBC Driver]Expected lexical element not found: <identifier>

How can I count distinct column values using ODBC 7.0.3?