0

I executed a query in TDengine.

My SQL statement is :

select  count(distinct id_number) from attendance where project_number = "202201130002" and attendance_mark = "1" group by id_number;

It reported an error:

DB error: syntax error near "distinct id_number) from attendance where project_number = "202201130002" and attendance_mark = "1" group by id_number;" (0.000143s)

Is there any syntax error in this sentence? How should I write it?

superman
  • 1
  • 4

0 Answers0