sql ×Ö¶ÎÏà¼Ó

ÊÇÕâÑùµÄ£¬name  wz
        Íõ      a
        Íõ      b
        Íõ      a
ÎÒÏëµÃ³ö    Íõ a2 b1

»¹ÓоÍÊÇÔ·ÝÄÚµÄÐÅÏ¢£¬Ê±¼ä¸ñʽÊÇÿÔµÄ22ÈÕ9µã µ½ÏÂÔÂ22ÈÕ8µãµÄÊý¾Ý¡£

---

¿´¿´

---

yun

---

ÊÇʲôѽ

---

ʲô°¡

---

SQL code:
select name,column1=(select sum(wz) from tb where wz='a' group by name),
column2=(select sum(wz),date from tb where wz='b' group by name)
from tab
where date between ... and ...

---

select name,column1=(select sum(wz) from tb where wz='a' group by name),
column2=(select sum(wz),date from tb where wz='b' group by name)
from tab
where date between ...  and ...

---

SQL code:


--sinpoal
--------Êý¾Ý----------
if object_id('ta')is not null drop table ta
if object_id('tt')is not null drop table tt
create table ta([name] char(6),wz char(1))
insert ta
select 'Íõ','a' union all
select 'Íõ','b' union all
select 'Íõ','a'
---------statement----------
select [name],wz+cast (count(wz) as char(1))as he into tt from ta group by wz,[name]
select * from tt
-----result-----------
/*
[name]