SELECT DISTINCT

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
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.