解决方案 »
- JSP过时了?
- 请教一个jsp进行逐行输出的问题,求高手指导。。。。。
- 一个基础问题static
- Struts2 <s:property> 问题
- JMS createSession(false, Session.AUTO_ACKNOWLEDGE); 两个参数不同组合下的区别
- 这段代码什么意思?比较简单
- 懂JSP就能找到工作了吗?
- weblogic 和 weblogic workshop?
- 请问如何建立一个JAVA开发WebServices的环境?
- SSH框架中javax.persistence.TransactionRequiredException
- 技术讨论:MQ的应用与产生背景
- Spring中创建bean的错误
SELECT m.m , s.m , y.m
FROM (SELECT M FROM zmy WHERE STATE='月') as m,
(SELECT M FROM zmy WHERE STATE='季') as s,
(SELECT M FROM zmy WHERE STATE='年') as y你这样试试!
distinct *
set @bnum =0;
set @cnum = 0;
select anum, bnum, cnum, A, B, C from
(select (@anum := @anum + 1) as anum, zmy.月度 as 月度 from zmy where zmy .A is not null) as AA ,
(select (@bnum := @bnum + 1) as bnum, zmy.季度 as 季度 from zmy where zmy .B is not null) as BB,
(select (@cnum := @cnum + 1) as cnum, zmy.年度 as 年度 from zmy where zmy .C is not null) as CC
where anum=bnum and bnum=cnum行号一致