多个条件的多个条件在一个查询中COUNT()(MySQL)
我有这些查询:SELECT COUNT(*) FROM t_table WHERE color = 'YELLOW';SELECT COUNT(*) FROM t_table WHERE color = 'BLUE';SELECT COUNT(*) FROM t_table WHERE color = 'RED';有没有办法在查询中获得这些结果?
解决方案:
SELECT color,COUNT(*) FROM t_table GROUP BY color
页:
[1]