我表中有一字段。ksjh该字段 可填“1,4,14,5,15”
现在我想统计 ksjh该字段 等于4，和等于14的一共有多少人请问命令怎么用？

?[=4人],OCCURS([4],KSJH)
?[=14人],OCCURS([14],KSJH)

根据楼主的数据特点，字串两边加上 豆 号,再作比较.

注：以下是引用楼主的说法，其实不是 “等于”

SELECT COUNT(KSJH) 人数 FROM 表 WHERE OCCURS(",4,",","+ALLTRIM(KSJH)+",")>0  && ksjh该字段 等于4 人数
SELECT COUNT(KSJH) 人数 FROM 表 WHERE OCCURS(",14,",","+ALLTRIM(KSJH)+",")>0  && ksjh该字段 等于14 人数

KSJH等于4，或 等于14的 人数总和 SELECT COUNT(KSJH) 人数 FROM 表 WHERE OCCURS(",4,",","+ALLTRIM(KSJH)+",")>0 or OCCURS(",14,",","+ALLTRIM(KSJH)+",")>0



KSJH等于4，并且也等于14的 人数总和
SELECT COUNT(KSJH) 人数 FROM 表 WHERE OCCURS(",4,",","+ALLTRIM(KSJH)+",")>0 and OCCURS(",14,",","+ALLTRIM(KSJH)+",")>0



[ 本帖最后由 kiff 于 2013-4-12 07:52 编辑 ]

sele ksjh,coun(ksjh) 人数 from ksjh where ksjh=4 grou by ksjh ;
union sele ksjh,coun(ksjh) 人数 from ksjh where ksjh=14 grou by ksjh