【订单生产源码】【广告ps源码】【cr公式源码】麻将源码 sql_麻将源码租
时间：2024-12-26 11:44:04 分类：知识 来源：myeclipse源码怎么保存
1.如何将SQL查询结果合并成多列？
如何将SQL查询结果合并成多列？
select a.姓名,麻将l麻码租订单生产源码
a.身高,
a.体重,
a.三围,
sum(b.语文) as 语文总分,
sum(b.数学) as 数学总分,
sum(b.英语) as 英语总分,
sum(b.麻将) as 麻将总分,
sum(b.斗地主) as 斗地主总分
from 基本情况 as a,考试成绩 as b where a.姓名=b.姓名
group by a.姓名,a.身高,a.体重,a.三围
你三围写错了吧
