Active Query Builder support area

COUNT Distinct

Avatar
  • updated
  • Completed
Hi,

Is it possible to use COUNT Distinct in the query builder as part of the aggregate functions?

For example, build a query such as:

SELECT COUNT(DISTINCT Col1) AS Count, col2 FROM TableName

Avatar
Andrey Zavyalov, PM
Thank you for your report. This problem is fixed 2.8.11.
Avatar
Michael
We currently have the syntax prodiver set to MSSQLSyntaxProvider
Avatar
Andrey Zavyalov, PM
The content of this list depends on the syntax provider being used. What is yours?
Avatar
Michael
Hi Sergey - thanks for the quick reply. I do not seem to have this as an option?

Using ASP.NET Edition 2.8.3.683


Avatar
Andrey Zavyalov, PM
Yes, it is possible. Select the "Count Distinct" from the drop-down list of aggregates to get the needed result query.