¼òµ¥µÄsqlÓï¾ä

±íaÈ磺
    sex 
    0
    1
    0
    1
    1
0´ú±íÅ®£¬1´úÂëÄÐ
Ïë²é³öÀ´µÄ½á¹ûΪ
  ÐԱ𠠺ϼÆ
    ÄР     3
    Å®      2
ÔõôдsqlÓï¾ä£¿

---

SQL code:
select ÐÔ±ð=case sex when 0 then 'Å®' else 'ÄÐ' end,
ºÏ¼Æ=count(1)
from ±ía group by sex order by sex desc

---

select (case Sex when 0 then 'Å®' else 'ÄÐ' end) as ÐÔ±ð ,count(sex) from Tb
group by Sex

---

Â¥ÉÏÕý½â

---

ÒýÓÃ

SQL codeselect ÐÔ±ð=case sexwhen0then'Å®'else'ÄÐ'end,
      ºÏ¼Æ=count(1)from ±íagroupby sexorderby sexdesc

¿ÉÒÔ³öÀ´½á¹ûµ«ÊÇÓÐÁ½ÌõÄУ¬ÓÃdistinct±¨´í

---

ÒýÓÃ

select (case Sex when 0 then 'Å®' else 'ÄÐ' end) as ÐÔ±ð ,count(sex) from Tb
group by Sex

½á¹ûΪ
    ÄР 0
    Å®  2
  ÄР 3

---

select (case sex when 0 then  'ÄÐ' else 'Å®' end)  as 'ÐÔ±ð',count(sex) as 'ºÏ¼Æ' from table1
group by sex

---

²»ºÃÒâ˼ ÊÇÎÒÊý¾Ý¿âÖÐÓÐ