sales±í id name partid 1 ÊÛa ÏúÊÛ²¿ 2 ÊÛb ÏúÊÛ²¿ 3 ÊÛc Êг¡²¿ ÇëÓÃSQL²éÕÒ¸÷¸ö²¿ÃŵÄÄÐÅ®ÈËÊý·Ö±ðÊǶàÉÙ£¬ÈçÒÔÏÂÐÅÏ¢£º Part ÄÐ Å® ÏúÊÛ²¿ ?ÈËÊý ?ÈËÊý Êг¡²¿ ?ÈËÊý ?ÈËÊý select b.partid,a.gender,count(1) from users a,sales b where a.salesid=b.id group by b.partid,a.gender SQL code: SELECT S.PARTID,SUM(DECODE(U.GENDER,'ÄÐ'£¬1£¬0)) ¡°ÄС±£¬SUM(DECODE(U.GENDER,'Å®'£¬1£¬0)) ¡°Å®¡± from USERS U,SALES S WHERE U.SALESID=S.ID GROUP BY S.PARTID;
²»ºÃÒâ˼£¬¿´µÄÂí»¢ÁË¡£ select b.partid, sum(a.gender, 'ÄÐ', 1, 0) ÄÐ, sum(a.gender, 'Å®', 1, 0) Å®, from users a, sales b where a.salesid = b.id group by b.partid
Çë½Ì£ºoracleÊý¾Ý¿â½ø³ÌÕ¼ÓÃÒ»Ö±²»¶ÏÉÏÕÇ£¬´óÔ¼20¶àÌìºó£¬¾Í»áµ¼ÖÂϵͳÐéÄâÄÚ´æ²»×㣬Á¬½Ó¶Ïµô£¬ÇëÎÊÔõô»áÊ£¿ Ö»ÓÐÖØÆô·þÎñÆ÷²Å¿ÉÒÔÔÙÕý³£ÔËÐУ¬ÖÜÆÚÐÔ³öÏÖÐéÄâÄÚ´æ²»×ãÏÖÏó£¡ ¼±£¡£¡£¡£¡ÏȸÐл´Í½Ì£¡ which os ......