使用having统计次数的用法
摘要：
select cardId as 卡号,count(cardId) as 消费次数,formatdatetime(consumeTime,2) as 消费日期 from F_Consume where consumeTime between #2010-11-01 00:00:00# and #2010-11-30 23:59:59#group by formatdatetime(consumeT... 阅读全文
posted @ 2010-12-01 16:19 悟生慧 阅读(681) 评论(0) 推荐(0) 编辑
