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也要从前面三个字段的不同记录来统计

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

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