Help: a difficult SQL request

From: charlie cs <cs3526(no-spam)_at_yahoo.com>
Date: Sat, 22 Feb 2003 18:41:19 GMT
Message-ID: <jvP5a.9872$_J5.3067@nwrddc01.gnilink.net>

we have a huge table, with data coming in every minute, table will be like this
TIME VOLULME

---

1:01        12
1:02        13
1:04        15
1:05         3

.......

but sometimes the data collector went bad, so the volume will inherit the privious one, the data will be like

TIME VOLULME

---

1:01        12
1:02        13
1:04        15
1:05         3


.......

1.10        3
1.11        3
1.12        3
1.13        3
1.14        3
1.15        3
1.16        3

...............

How could we find those records which did change for at least 8 minutes?

Thanks for your help Received on Sat Feb 22 2003 - 12:41:19 CST