SELECT inside a COUNT

Question

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

User · Answer

SELECT a AS current a  COUNT    AS b      SELECT COUNT    FROM t WHERE a   current a AND c    const    as d    from t group by a order by b desc

User · Answer

You can move the count   inside your sub-select   SELECT a AS current a  COUNT    AS b       SELECT COUNT    FROM t WHERE a   current a AND c    const    as d     from t group by a order by b desc

User · Answer

Use SELECT COUNT    FROM t WHERE a   current a AND c    const    as d

User · Answer

You don t really need a sub-select   SELECT a  COUNT    AS b     SUM  CASE WHEN c    const  THEN 1 ELSE 0 END   as d     from t group by a order by b desc

[sql] SELECT inside a COUNT

Examples related to sql

Examples related to mysql