34,575
社区成员
发帖
与我相关
我的任务
分享
--数据量在130W左右
select projectid,username,completestate,count(1) as amount from projectlink201209 where starttime between
'2012-10-29 00:00:00' and '2012-10-29 23:59:59' and len(username)>0 and len(username)<14 and
isnull(completestate,'') in ('C','S','Q') group by projectid,completestate,username
SELECT projectid,
username,
completestate,
Count(1) AS amount
FROM projectlink201209
WHERE starttime BETWEEN '2012-10-29 00:00:00'
AND '2012-10-29 23:59:59'
AND Len(username) > 0
AND Len(username) < 14
AND completestate IN ('C',
'S',
'Q')
GROUP BY projectid,
completestate,
username
select projectid,username,completestate,count(1) as amount from projectlink201209 where starttime between
'2012-10-29 00:00:00' and '2012-10-29 23:59:59' and len(username)>0 and len(username)<14 and completestate in ('C','S','Q') group by projectid,completestate,username