Active Query Builder support area

COUNT Distinct

Avatar
Michael
  • 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

Replies 5
Avatar
0
Andrey Zavyalov, PM
Thank you for your report. This problem is fixed 2.8.11.
Avatar
0
Michael
We currently have the syntax prodiver set to MSSQLSyntaxProvider
Avatar
0
Andrey Zavyalov, PM
The content of this list depends on the syntax provider being used. What is yours?
Avatar
0
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
0
Andrey Zavyalov, PM
Yes, it is possible. Select the "Count Distinct" from the drop-down list of aggregates to get the needed result query.