accessͳ¼Æ

ÎÒҪͳ¼ÆaccessÖÐij¸ö±íÖеļǼ£¬ÆäÖÐsexΪ1µÄÓжàÉÙÌõ£¬Îª2µÄÓжàÉÙÌõ¡£²¢½«Êý¾ÝÏÔʾÔÚlabelµÄcaptionÉÏ£¬Ó¦¸ÃÈçºÎдÄØ¡£

---

ÓõÄadoquery

---

¿ÉÒÔ Ê¹ÓÃÁ½´ÎsqlÓï¾äÀ´µÃµ½

---

ÒýÓÃ

C/C++ code
AnsiString Str ;
Str="select count(*) as ct from tablename where sex=1"//or//Str ="select count(*) as ct from tablename where sex=2"ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->S?-

Ç¿

---

Â¥ÉϵĶ¼ËµÍêÁË¡£¡£´úÂëÒ²¸øÁË¡£¡£
ÄÇÎÒÀ´´ò¸ö½´ÓͺÃÁË¡£¡£¡£¡£

---

SELECT sex, count(*) as ct
from tablename
GROUP BY sex


Ò»´Î¼´¿ÉÍê³É

---

Ò»´ÎÄܲéѯÍê³É.SQLÓï¾äÈçÏÂ

C/C++ code:
AnsiString sSQL;
sSQL = "select sum(case when sex = 1 then 1 else 0 end) sex1,sum(case when sex = 2 then 1 esle 0 end) sex2
from table"
ADO->SQL->Text = sSQL;
ADO->Open;
lable->Caption = "ÐÔ±ðΪ1µÄÓÐ" + ADO->FieldByName("sex1")->AsString + "Ìõ¼Ç¼,ÐÔ±ðΪ2µÄÓÐ" + ADO->FieldByName("sex1")->AsString + "Ìõ¼Ç¼";


¸ø·Ö°É..

---

ÒýÓÃ

SELECT sex, count(*) as ct
from tablename
GROUP BY sex


Ò»´Î¼´¿ÉÍê³É

Õâ¸ö²ÅÊÇ×î¼ò±ãµÄ·½Ê½

---

лл¸öλµÄ°ï棬¸ã¶¨