天 天真 Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-09 #2 SELECT COUNT(*) AS Expr1 FROM dbo.a GROUP BY x
O ourself Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-09 #3 Supposed you have a table list(id INT), try the following: SELECT id, COUNT(id) total FROM list GROUP BY id
Supposed you have a table list(id INT), try the following: SELECT id, COUNT(id) total FROM list GROUP BY id
M meyxiao Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-09 #4 相同的SQL 我写过 可是报错 该字段不是关键字段
S sonie Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-09 #6 用group by可能是不行的 楼上一位兄弟的稍改下 SELECT id, COUNT(id) as total FROM list GROUP BY id 计算的是不同id的个数. 只能带参数进去计算某个指定id的记录个数 select count(*) from table where id=@id
用group by可能是不行的 楼上一位兄弟的稍改下 SELECT id, COUNT(id) as total FROM list GROUP BY id 计算的是不同id的个数. 只能带参数进去计算某个指定id的记录个数 select count(*) from table where id=@id
U ugvanxk Unregistered / Unconfirmed GUEST, unregistred user! 2002-04-09 #7 SELECT x, COUNT(*) AS Expr1 FROM dbo.a GROUP BY x 应该有x,字段名
