Mysql查询根据条件选择不同记录？

我有这样的表结构..ext_no , value..我想根据条件选择不同的记录..比如当计数时ext_no is 超过两个 and 当且仅当所有这些ext_no value为零.. 我想要下面给出的预期结果...比如..如何编写 mysql 查询这个..？任何帮助将不胜感激..提前致谢..

表结构：

CREATE TABLE `test` (
  `ext_no` int(5) default NULL,
  `value` int(3) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `test`
--

INSERT INTO `test` (`ext_no`, `value`) VALUES
(12133, 0),
(12133, 0),
(12133, 0),
(22222, 0),
(44226, 0),
(44226, 0),
(44226, 1),
(44226, 2),
(99902, 1),
(99902, 2),
(99902, 3),
(11505, 0),
(11505, 0),
(11505, 0),
(11505, 0);

预期结果：

ext_no  value
12133     0
11505     0

编辑：我尝试过-

select distinct ext_no, value from test where value ='0' order by ext_no DESC;

count skips null价值观。所以你可以count a case值为的表达式0，然后使用having检查此计数是否等于总计数的条件：

SELECT   ext_no, MAX(value)
FROM     test
GROUP BY ext_no
HAVING   COUNT(*) > 2 AND 
         COUNT(*) = COUNT(CASE value WHEN 0 THEN 1 END)