|
本帖最后由 dengjq2000 于 2014-11-21 21:46 编辑
各位高手,有要求如下:先谢谢大家了!
工号 | 标示 | 班长 | 排长 | 连长 | | 要求统计标示为A的,在连长1下面,有多少个符合前面条件的班长。 | 10001 | A | 111 | 11 | 1 | | | | | | | 10002 | A | 111 | 11 | 1 | | | | | | | 10003 | T | 111 | 11 | 1 | | 班长数 | | | | | 10004 | T | 111 | 11 | 1 | | | | | | | 10005 | T | 222 | 11 | 1 | | | | | | | 10006 | T | 222 | 11 | 1 | | | | | | | 10007 | T | 222 | 11 | 1 | | | | | | | 10008 | T | 222 | 11 | 1 | | | | | | | 10009 | A | 333 | 22 | 1 | | | | | | | 10010 | A | 444 | 22 | 1 | | | | | | | 10011 | T | 333 | 22 | 1 | | | | | | | 10012 | T | 333 | 22 | 1 | | | | | | | 10013 | T | 444 | 22 | 1 | | | | | | | 10014 | A | 444 | 22 | 1 | | | | | | | 10015 | A | 444 | 22 | 1 | | | | | | | 10016 | A | 555 | 22 | 1 | | | | | | | 10017 | A | 555 | 22 | 1 | | | | | | | 10018 | T | 555 | 22 | 1 | | | | | | | 10019 | T | 555 | 22 | 1 | | | | | | | 10020 | A | 555 | 22 | 1 | | | | | | | 10021 | A | 555 | 22 | 1 | | | | | | | 10022 | T | 555 | 22 | 1 | | | | | | | 10023 | T | 555 | 22 | 1 | | | | | | | 10024 | T | 555 | 22 | 1 | | | | | | | 10025 | T | 666 | 33 | 1 | | | | | | | 10026 | A | 666 | 33 | 1 | | | | | | | 10027 | A | 666 | 33 | 1 | | | | | | | 10028 | A | 666 | 33 | 1 | | | | | | | 10029 | T | 666 | 33 | 1 | | | | | | | 10030 | A | 666 | 33 | 1 | | | | | | | 10031 | A | 666 | 33 | 1 | | | | | | | 10032 | A | 666 | 33 | 1 | | | | | | | 10033 | A | 666 | 33 | 1 | | | | | | | 10034 | T | 777 | 33 | 1 | | | | | | | 10035 | T | 777 | 33 | 1 | | | | | | | 10036 | A | 777 | 33 | 1 | | | | | | |
|
|