建一张表如下:表名为 number
要求找出num列连续出现三次或三次以上的数据:
select * from number where id in (
select distinct n1.id from number n1,number n2,number n3
where (n1.num = n2.num and n2.num
建一张表如下:表名为 number
要求找出num列连续出现三次或三次以上的数据:
select * from number where id in (
select distinct n1.id from number n1,number n2,number n3
where (n1.num = n2.num and n2.num