常用查询语句

java

分组统计数量
SELECT distinct status, count(*) FROM xxx_table group by status

SELECT distinct template, count(1) as count FROM domainconfig  group by template  and template='user' order by count desc

java

where执行顺序是从左往右执行的，

遵守原则：排除越多数据的条件放在第一个。