select A.ID,Sum(B.Fraction) as '汇总' From User_Info A left join GradeInfo B on A.ID=B.UserInfoId Group by A.id这样写只显示两例 user_info中的 id字段 和 汇总 现在我想显示第三行 user_info 中的user_name 应该怎么样写
解决方案 »
- ====== 在XML列中插入CDATA节的问题,找了很久无解 =====
- 数据库删除重复数据,并保留第一条重复数据
- sql server 2008 返回数据丢失字段
- left join为什么结果不是我想要的
- 100分求Sql语句,谢谢
- 数据库设计(海量数据性能)
- 急!!!!bulk insert语句导数据到表中,如果数据量稍大,怎么会把文本里的内容顺序打乱?有什么办法可以解决吗?
- 极菜问题,但对我 很重要,希望能 帮我一下,sql server和mysql 有什么区别,我应该学哪个 98系统能 不能 安装sql2000
- 存储过程中的临时表,如何在VB中引用成recordset呢?
- SELECT ROUND (0.6,0)
- 简单的数据算法~~~~大虾们帮帮忙
- 设计一个会员系统的数据库(新闻系统)
A.ID,A.user_name
Sum(B.Fraction) as '汇总'
From
User_Info A left join GradeInfo B
on A.ID=B.UserInfoId
Group by A.id ,A.user_name?
From User_Info A
left join GradeInfo B
on A.ID=B.UserInfoId
Group by A.id,a.user_name
A.ID,A.[user_name]
Sum(B.Fraction) as '汇总'
From
[User_Info] A left join GradeInfo B
on A.ID=B.UserInfoId
Group by A.id ,A.[user_name]
From User_Info A left join GradeInfo B on A.ID=B.UserInfoId
Group by A.id,a.user_name
FROM
(
select
A.ID
Sum(B.Fraction) as '汇总'
From
[User_Info] A left join GradeInfo B
on A.ID=B.UserInfoId
Group by A.id)AS A ,[User_Info] B WHERE A.ID=B.ID?
from
(
select A.ID,Sum(B.Fraction) as '汇总'
From User_Info A
left join GradeInfo B
on A.ID=B.UserInfoId
Group by A.id
) a
left join user_info b
on a.id=b.id
无论是不是相同,下面都实现
select A.ID,a.user_name,Sum(B.Fraction) as '汇总'
From User_Info A left join GradeInfo B on A.ID=B.UserInfoId
Group by A.id,a.user_name但如果要user_name与id无关,又要不放入group by,象楼上一样,就没什么意义了