sql sum函数和count函数连用:
范例如下:
SELECT sum(cnt) from (select count(*) as cnt FROM [users]..users
WHERE adddate>'2010-10-08' AND adddate<'2010-10-14') as tmp
sql sum函数和count函数连用:
范例如下:
SELECT sum(cnt) from (select count(*) as cnt FROM [users]..users
WHERE adddate>'2010-10-08' AND adddate<'2010-10-14') as tmp