select count(*) from table 可以查出来有多少条记录。那 下面这个sql 怎么 count 呢??SELECT b.pid
FROM project_basic AS b, project_type AS t
WHERE b.pid = t.pid
AND b.active = '1'
AND t.active = '1'
AND substring( b.lid, 1, 4 ) = '1002'
GROUP BY b.name
FROM project_basic AS b, project_type AS t
WHERE b.pid = t.pid
AND b.active = '1'
AND t.active = '1'
AND substring( b.lid, 1, 4 ) = '1002'
GROUP BY b.name
FROM project_basic AS b, project_type AS t
WHERE b.pid = t.pid
AND b.active = '1 '
AND t.active = '1 '
AND substring( b.lid, 1, 4 ) = '1002 '
FROM project_basic AS b, project_type AS t
WHERE b.pid = t.pid
AND b.active = '1 '
AND t.active = '1 '
AND substring( b.lid, 1, 4 ) = '1002 '
GROUP BY b.name这样不就行了么
因为 最后是 按照 b.name 分组的。比如查出的数据是pid
2
1
4
1
2
1
3
.
.
.
问题是,我就要统计出一共有多少组。2楼和3楼的都不对的。
(SELECT count(b.pid)
FROM project_basic AS b, project_type AS t
WHERE b.pid = t.pid
AND b.active = '1 '
AND t.active = '1 '
AND substring( b.lid, 1, 4 ) = '1002 '
GROUP BY b.name) a