我测试的,看看是不是你要的吧。
CREATE TABLE T1
(
ID INT,
NAME VARCHAR(45)
)
INSERT INTO T1 VALUES(1,'AA')
INSERT INTO T1 VALUES(2,'CC')
INSERT INTO T1 VALUES(3,'DD')
INSERT INTO T1 VALUES(4,'BB')
INSERT INTO T1 VALUES(5,'AA')
INSERT INTO T1 VALUES(6,'CC')
INSERT INTO T1 VALUES(7,'AA')
INSERT INTO T1 VALUES(8,'BB')
INSERT INTO T1 VALUES(9,'EE')
INSERT INTO T1 VALUES(10,'EE')
INSERT INTO T1 VALUES(11,'WW')
create view MyView
as
SELECT NAME FROM T1 group by name HAVING COUNT(NAME)=2
select COUNT(*) from MyView
结果为:3
追问不能分步 ,我已解决了。。