| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tough SQL Problem
Hmm....just the one column? You need another column, by which you can
establish order. There is no order inherent in a relational table. So,
if you had another column, say, sequence_number, or a date_time_col or
something, you could order by that, and relative to that, determine the
largest consecutive occurances of '1'. (I'm thinking lag()/lead() here,
off the top of my head.)
I would argue that without another column to order by, it's not possible, cause there's no way to determine the order of the rows.
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
"There are 10 types of people in the world: Those who understand binary, and those who don't."
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ethan Post
Sent: Wednesday, February 08, 2006 12:47 PM
To: oracle-l
Subject: Tough SQL Problem
I have a log table that is logging various PLSQL calls. Assume the table looks like this...
PROCEDURE_ID
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?
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 08 2006 - 12:03:40 CST
 |
 |