Tough SQL Problem

From: Ethan Post <post.ethan_at_gmail.com>
Date: Wed, 8 Feb 2006 11:46:56 -0600
Message-ID: <357b48a90602080946l9eecffdq3006736a1f4149e0@mail.gmail.com>

I have a log table that is logging various PLSQL calls. Assume the table looks like this...

PROCEDURE_ID

---

1
2
1
1
1
1
1
2
1
1
2
1

Looking at this I can see that the max times 1 was called consecutivley is 5. I have no clue how I would do this in SQL without writing a function of some sort to keep a count and return the max count. Anyone know if this can be done using and built in functions?

• Ethan -- http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 08 2006 - 11:46:56 CST