Tough SQL Problem
- From: Ethan Post <post.ethan@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 8 Feb 2006 11:46:56 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
