如何得到分组查询后的记录数?例如我用1、
SELECT COUNT(dw) AS aaa FROM nqfsh WHERE (dd_year = 2008)
知道 aaa 为 5000 条
而用2、
SELECT dw FROM nqfsh WHERE (dd_year = 2008) GROUP BY dw
知道分组后有记录20条,(数出来的)那么,我如何像 1 那样 得到 2 的分组后的记录数?
SELECT COUNT(dw) AS aaa FROM nqfsh WHERE (dd_year = 2008)
知道 aaa 为 5000 条
而用2、
SELECT dw FROM nqfsh WHERE (dd_year = 2008) GROUP BY dw
知道分组后有记录20条,(数出来的)那么,我如何像 1 那样 得到 2 的分组后的记录数?
SELECT dw,COUNT(dw) AS aaa
FROM nqfsh
WHERE (dd_year = 2008)
GROUP BY dw
SELECT dw,COUNT(dw) as countDW FROM nqfsh WHERE (dd_year = 2008) GROUP BY dw
count(distinct dw),count(*)
from
nqfsh
SELECT COUNT(dw) AS aaa FROM nqfsh
WHERE (dd_year = 2008)
group by dw