mysql 语句学习

Firstly, we need to know what contents tables have!

select Date,sum(todayConsume) from industry2_consume where 2_department in (‘V1‘,‘V2‘,‘地管‘,‘武管‘,‘地新‘,‘武新‘) and 2_industry=‘高教自考‘ group by Date;

select Date,sum(todayConsume) from industry2_consume where 2_department=‘新客户部‘ and 2_department=‘VIP二部‘ and 2_department=‘武汉客关部‘ and 2_department=‘地市客管部‘ and 2_industry=‘高教自考‘ group by Date limit 156,168;

select sum(todayConsume) from industry2_consume where 2_department in (‘V1‘,‘V2‘,‘地管‘,‘武管‘,‘地新‘,‘武新‘) and 2_industry=‘高教自考‘ and Date>=‘2015-06-06‘ and Date<=‘2015-06-17‘;

mysql 语句学习

标签：