如果name是唯一的,如下: select a.name,a.bm,b.je from table1 a, (select name,sum(money) from table1 group by name) b where a.name = b.name order by a.bm如果name不唯一就将name改为相应唯一的字段
select name,(select isnull(dept_name,"") from dept where dept.name = emp.name) as dept,sum(money) from amp group by dept,name order by dept,name
select DISTINCT name,dept,sum(money) from table1 group by dept,name order by dept,name
select a.name,a.bm,b.je
from table1 a,
(select name,sum(money) from table1 group by name) b
where a.name = b.name
order by a.bm如果name不唯一就将name改为相应唯一的字段