www.5129.net > SELECT uiD,Count(*) FROM mB_u_ACtivE group By u...

SELECT uiD,Count(*) FROM mB_u_ACtivE group By u...

count(*) as number 取个别名 下面用rs("number")

你的配置文件没有 被加载起来 所以无法使用对象查询 只能使用SQL 查询

分组查询,你前面查询的列不能用*号, select t.u_id from (select * from loginrecord order by l_time desc) t group by t.u_id 不知是否正确,你试试...

网站地图

All rights reserved Powered by www.5129.net

copyright ©right 2010-2021。
www.5129.net内容来自网络,如有侵犯请联系客服。zhit325@qq.com