Details
Details
Assignee
Brad Wood
Brad WoodReporter
Brad Wood
Brad WoodLabels
New Issue warning screen
Before you create a new Issue, please post to the mailing list first https://dev.lucee.org
Once the issue has been verified, one of the Lucee team will ask you to file an issue
Priority
Created 17 September 2022 at 05:17
Updated 17 September 2022 at 05:17
Some DB’s allow you to select more than one column when using DISTINCT in the count() function. It’s not a common use case, but something we could support with some refactoring.
https://www.w3resource.com/sql/select-statement/queries-with-distinct-multiple-columns.php
SELECT count(distinct col1, col2) from Qry