SELECT DISTINCT is supported, but it is limited internally by the group by cardinality limits. To make a distinct selection from a query that uses GROUP BY, you will need to add a new outer select.
Example:
SELECT DISTINCT fieldX FROM ( SELECT fielda, fieldb, fieldX FROM table1 GROUP BY fieldb ) AS inner_query
Comments
Please sign in to leave a comment.