¼±£¬Çë½Ìsqlͳ¼Æ²éѯ

id      name    age    sex      pass    type  parentType
1 aa 10 m 12345 A    1
7 bb 20 f A    1
8 cc 30 m B    1
9 ee 40 f B    1
11 jack 18 f jack B    1
12 mar 35 f mar A    1
13 win 32 m B    1

ÈçºÎд²éѯÓï¾äʹµÃ½á¹ûΪ£º
sumrate--×ÜÃÜÂëʹÓÃÂÊ    sumpass--ijÀàÐÍÃÜÂëʹÓÃÊý    allpass--ijÀàÐÍÓû§µÄÊýÁ¿
sumrate    parentType  type  sumpass  allpass  rate
42.86%    1            A    2        3        66.67%
42.86%    1            B    1        4        25%

---

²»ÊÇд¹ýÁËÂð

---

ÒýÓÃ

²»ÊÇд¹ýÁËÂð

.......

---

×ÜÃÜÂëʹÓÃÂÊÊÇÔõôËã³öÀ´µÄ£¿

---

¼ÓÁËÒ»¸ö×ֶΣ¬¶àÁËÒ»¸öͳ¼Æ£¬Å¼ÓÖ²»»áÁË

---

×ÜÃÜÂëʹÓÃÂÊÊÇ£¬sumpassµÄºÍ³ýÒÔallpassµÄºÍµÄÖµ

---

42.86% ÔõôËãµÄ

---

7¥ǰ±²£¬ÎÒÌ«³ç°ÝÄãÁË

---

--²âÊÔÊý¾Ý
declare @table table([id] int,[name] varchar(4),[age] int,[sex] varchar(1),[pass] varchar(5),[type] varchar(1),[parentType] int)
insert into @table
select 1,'aa',10,'m','1