(a.id = b.id-1 and b.id+1 = c.id)
2 3-1 3+1 4 -------最小
2 1+1 2+1 3 ------中间
2 1+1 1-1 0 -------最大
select distinct a.* from stadium a,stadium b,stadium c where a.people>99 and b.people>99 and c.people>99 and
(a.id=b.id-1 and b.id+1=c.id or
a.id=b.id+1 and a.id+1=c.id or
a.id=b.id+1 and b.id-1=c.id)
order by a.id
原题目: