Can an analytic function do the following?

running Oracle 9i R2 on Sun Starfire server with Sun OS

We have table A with the following structure

Date        hour      tagname           value
6/1/03          6       A                       100
6/1/03          7       A                       200
6/1/03          8       A                       100


..

6/1/03          23      A                       95
6/1/03          6       B                       53
6/1/03          7       B                       20
6/1/03          8       B                       30


..

6/1/03          23      B                       55

We want to find tags where the value for 3 consective hours is the same

for exampe

6/1/03         11       F                       30
6/1/03         12       F                       30
6/1/03         13       F                       30

The values have to be consectivie not just appearing 3 times in a day

Can an analytical function do this? We want to avoid a stored procedure for a variety of reasons (we have 3,000,000 rows to go thru and loading each row and comparing it to the previous and so forth will be too slow, we hope an AF will be faster) Received on Mon Jun 30 2003 - 18:57:12 CDT