问题描述:
譬如数据库一个表A中的字段a_a的值为:sum(gz.ylgz) as "应领工资",sum(gz.slgz) as "实领工资"
现在有一条SQL语句,譬如:select xm as "姓名", ryid as "RYID" from gz where gz.id = 3
问题:如何组织成如下的SQL语句:
select xm as "姓名", ryid as "RYID",sum(gz.ylgz) as "应领工资",sum(gz.slgz) as "实领工资" from gz where gz.id = 3 group by ryid,xm
要求:sum(gz.ylgz) as "应领工资",sum(gz.slgz) as "实领工资" 这句代码是从A表中的a_a字段随时查询而出;
譬如数据库一个表A中的字段a_a的值为:sum(gz.ylgz) as "应领工资",sum(gz.slgz) as "实领工资"
现在有一条SQL语句,譬如:select xm as "姓名", ryid as "RYID" from gz where gz.id = 3
问题:如何组织成如下的SQL语句:
select xm as "姓名", ryid as "RYID",sum(gz.ylgz) as "应领工资",sum(gz.slgz) as "实领工资" from gz where gz.id = 3 group by ryid,xm
要求:sum(gz.ylgz) as "应领工资",sum(gz.slgz) as "实领工资" 这句代码是从A表中的a_a字段随时查询而出;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货