strSQL ="SELECT COUNT(UserName) AS iCount , MobilePhoneType, KqStatus , KqTimeRecord from table group by MobilePhoneType, KqStatus , KqTimeRecord" sqlRst = sqlStmt.executeQuery(strSQL);
解决方案 »
- 有关ibatis事务问题
- Java Web开发
- 请JSF高手帮个忙..
- 高分求助,jsp页面作图问题:饼,堆积图,百分比堆积图
- 请问各位高手 在我的div中绑定的swf当div移动时swf移动滞后甚至不移动 是什么原因
- Jsp+servlet+javabean成熟商用系统源码(有在线演示)
- was 部署应用访问报错500
- 使用jsp+javaBean向MsSqlServer中存储图片!
- 求jdbc,用于sql2000server,100分
- jsp中长插入语句换行的连接!在先等待!
- 有熟悉strust的朋友帮忙看看!非常感谢!(100分相送)
- 怎么在dreamweaver中直接看到*.jsp的执行结果啊.
select UserName,KqStatus,KqTimeRecord,'iCount'=1 from KqRecord where KqTimeRecord >= '2003-01-01' and KqTimeRecord <= '2003-12-03'
union all
select UserName,KqStatus,EndDate,1 from qj where EndDate >= '2003-01-01' and EndDate <= '2003-12-03'
union all
select UserName,KqStatus,EndDate,1 from outuser where EndDate >= '2003-01-01' and EndDate <= '2003-12-03' order by UserName,KqStatuscompute sum(1) by UserName,KqStatus
我想把UserName....和sum的结果获取出来,但找不着方法,还请赐教
union all
select UserName,KqStatus,EndDate,1 from qj where EndDate >= '2003-01-01' and EndDate <= '2003-12-03'
union all
select UserName,KqStatus,EndDate,1 from outuser where EndDate >= '2003-01-01' and EndDate <= '2003-12-03' order by UserName,KqStatus用这个做VIEW,然后用GROUP BY 统计出结果集,别用compute