select count(distinct xh) as xh,(select count(*) from (select distinct xh,ch from hly)as a) as ch,(select count(*) from (select distinct xh,ch,lbh from hly)as b) as lbh,count(*) as xbh from (select distinct xh,ch,lbh,xbh from hly)as c

怎么在这段命令加个限制条件hly="黎建文"
即只统计黎建文的XH,CH，LBH，XHB

不知楼主是什么意思

就是想统计黎建文这个人有几个XH，CH，LBH，XHB

分组查询啊

select count(distinct xh) as xh,(select count(*) from (select distinct xh,ch from hly)as a) as ch,(select count(*) from (select distinct xh,ch,lbh from hly)as b) as lbh,count(*) as xbh from (select distinct xh,ch,lbh,xbh from hly)as c

这命令可以统计全部人的，现在就想只统计黎建文一个人的

意思就像这样

xh    ch   lbh  xbh
10    2    1    1
10    2    2    2
10    3    3    3
10    3    3    3
10    1    8    1
10    1    2    2
10    1    1    1
10    1    2    2
10    1    1    1
10    1    2    1
10    1    2    1
11    1    2    1
11    3    3    3
要统计出xh=2  ch=5(从不同的xh统计，10xh有1，2，3三个ch，11xh有1和3两个ch，共5个)  lbh=8（也要从不同的xh和ch号来统计)
xhb也要从前面三个字段的不同记录来统计

SELECT a.hly,a.xh,b.ch,c.lbh,d.xbh FROM ;
(SELECT hly,COUNT(distinct xh) xh FROM hly GROUP BY hly) a;
,(SELECT hly,COUNT(*) ch FROM (select distinct hly,xh,ch FROM hly) e GROUP BY hly) b;
,(SELECT hly,COUNT(*) lbh FROM (select distinct hly,xh,ch,lbh FROM hly) e GROUP BY hly) c;
,(SELECT hly,COUNT(*) xbh FROM (select distinct hly,xh,ch,lbh,xbh FROM hly) e GROUP BY hly) d;
  WHERE a.hly='黎建文' AND a.hly=b.hly AND a.hly=c.hly AND a.hly=d.hly

老大，太感谢了！
分虽然少了点！

[ 本帖最后由 hzh999 于 2013-6-5 15:10 编辑 ]