SQL server中，关于查询统计
SELECT COUNT(*) AS Expr1
FROM 表
WHERE (时间字段 BETWEEN '2013-4-2 00:05' AND '2013-4-2 22:00') AND (字段= '01') 这样统计01有多少02有多少太慢了。可以把01-09，每个字段值的数量分别统计出来的句。
SELECT å段,COUNT(*) AS Expr1
FROM 表
WHERE (æ¶é´å段 BETWEEN '2013-4-2 00:05' AND '2013-4-2 22:00') AND (å段 in ('01','02','03','04','05','06','07','08','09'))
group by å段
æè
SELECT å段,COUNT(*) AS Expr1
FROM 表
WHERE (æ¶é´å段 BETWEEN '2013-4-2 00:05' AND '2013-4-2 22:00') AND (å段 between '01' and '09')
group by å段追é®
FROM 表
WHERE (æ¶é´å段 BETWEEN '2013-4-2 00:05' AND '2013-4-2 22:00') AND (å段 in ('01','02','03','04','05','06','07','08','09'))
group by å段
æè
SELECT å段,COUNT(*) AS Expr1
FROM 表
WHERE (æ¶é´å段 BETWEEN '2013-4-2 00:05' AND '2013-4-2 22:00') AND (å段 between '01' and '09')
group by å段追é®
å¦ææ¥è¯¢å½ææ¯å¤©01-09æå¤å°æ°éè¯å¥å¯ä»¥åå°åï¼
追çä½ æ¯ä»ä¹æ°æ®åºåï¼
ä¸åæ°æ®åºæ¥æçåæ³ä¸å¤ªä¸æ ·
温馨提示：内容为网友见解，仅供参考
第1个回答 2013-03-21
直接把AND (字段= '01') 改成group by 字段
就行了吧
就行了吧
第2个回答 2013-03-21
SELECT 字段,COUNT(*) AS Expr1
FROM 表
WHERE (时间字段 BETWEEN '2013-4-2 00:05' AND '2013-4-2 22:00')
group by 字段
FROM 表
WHERE (时间字段 BETWEEN '2013-4-2 00:05' AND '2013-4-2 22:00')
group by 字段
第3个回答 2013-03-21
SELECT 字段,COUNT(*) AS Expr1
FROM 表
WHERE (时间字段 BETWEEN
'2013-4-2 00:05' AND '2013-4-2
22:00') AND (字段 between '01'
and '09')
group by 字段
FROM 表
WHERE (时间字段 BETWEEN
'2013-4-2 00:05' AND '2013-4-2
22:00') AND (字段 between '01'
and '09')
group by 字段
第4个回答 2013-03-21
and 字段 in (01,02,03......09)
相似回答
