2994
2995
a COUNT(DISTINCT a) SUM(DISTINCT a)
2995
2996
EXPLAIN SELECT COUNT(DISTINCT a, b), SUM(DISTINCT a) FROM t2 WHERE b = 42;
2996
2997
id select_type table type possible_keys key key_len ref rows Extra
2998
2999
SELECT COUNT(DISTINCT a, b), SUM(DISTINCT a) FROM t2 WHERE b = 42;
2999
3000
COUNT(DISTINCT a, b) SUM(DISTINCT a)