I would like to embed a SELECT inside a COUNT, but I can't find any examples.
#pseudosql
SELECT a AS current_a, COUNT(*) AS b,
COUNT( SELECT FROM t WHERE a = current_a AND c = 'const' ) as d,
from t group by a order by b desc
I would like to embed a SELECT inside a COUNT, but I can't find any examples.
#pseudosql
SELECT a AS current_a, COUNT(*) AS b,
COUNT( SELECT FROM t WHERE a = current_a AND c = 'const' ) as d,
from t group by a order by b desc