sql ²éѯÎÊÌâ - MS-SQL Server / »ù´¡Àà

id name gongzi 
1 ÕÅÈý 1000 
2 ÀîËÄ 2000 
3 ÕÅÈý 2000 
4 ÀîËÄ 3000 
5 ÍõÎå 3000 


ÎÒÓÐÕâÑùÒ»¸öÊý¾Ý¿â£¬ÏÖÔÚÎÒÒªsql²éѯµÄÊý¾ÝÊÇ ÕÅÈý£¬ÀîËÄ£¬ÍõÎåµÄ ºÏ¼ÆµÄ¹¤×Ê¡£¾ÍÊÇ°ÑËûÃǵĺÍÇó³öÀ´£¡ 

ÎÒÒªµÄ½á¹ûÊÇ £º 
id name gongzi 
1 ÕÅÈý 3000 
2 ÀîËÄ 5000 
3 ÍõÎå 3000 

ÕâÑùµÄSQL ÔõôдÄØ£¿

---

select name,¹¤×Ê=sum(¹¤×Ê)
from tb
group by name

---

select name,sum(gongzi)
from tb
group by name

---

select name,gongzi=sum(gongzi)
from tb
group by name

---

...

---

SQL code:
select name,sum(gongzi) as gongzi from tb group by name

---

SQL code:
²ä·Ö
select [name],
¹¤×Ê=sum(¹¤×Ê)
from tb
group by name

---

ͬÉÏ

ÒýÓÃ

SQL code²ä·Öselect[name],
¹¤×Ê=sum(¹¤×Ê)from tbgroupby name

---

SQL code:
create table tb(id int,name varchar(10),gongzi int)
insert into tb select
1 ,'ÕÅÈý', 1000 union all select
2 ,'ÀîËÄ', 2000 union all