select CustName,count(1) c from WorkOrder where CreateDate>'2016-5-1' and CreateDate<'2017-1-1'
group by CustName having c>100
order by c desc;
Mysql中的force index和ignore index
内容版权声明:除非注明,否则皆为本站原创文章。
select CustName,count(1) c from WorkOrder where CreateDate>'2016-5-1' and CreateDate<'2017-1-1'
group by CustName having c>100
order by c desc;
内容版权声明:除非注明,否则皆为本站原创文章。