select sum(eZl),sum(eBm),sum(ePd),sum(eTtm),sum(eSm),sum(eTxcl),sum(eSy),sum(eZj),sum(eJnml),sum(eHy),sum(eZd),sum(eSj),sum(eFg),sum(eSc) from Sys_EmOutput where eId='nmrs001' and eTime between '2009-11-09' and '2009-11-10'以上的语句执行后,都是无名列,请问列名如何变成我的列名??
from Sys_EmOutput where eId='nmrs001' and eTime between '2009-11-09' and '2009-11-10'
sum(eZl) as eZl,
sum(eBm) as ebm,
sum(ePd),
sum(eTtm),
sum(eSm),
sum(eTxcl),sum(eSy),sum(eZj),sum(eJnml),sum(eHy),sum(eZd),sum(eSj),sum(eFg),sum(eSc) from Sys_EmOutput where eId='nmrs001' and eTime between '2009-11-09' and '2009-11-10'