Find a break in number sequence [message #359781] |
Tue, 18 November 2008 03:49  |
jimit_shaili
Messages: 237 Registered: June 2006 Location: India, Ahmedabad
|
Senior Member |
|
|
Hi,
i have a data stored like this,
pid bagno
2722 1
2722 2
2722 3
2722 4
2722 5
2722 7
2722 8
2722 9
2722 10
2722 11
2722 12
i want result like this,
pid min(bagno) max(bagno)
2722 1 5
2722 7 12
Please provide me sum analytic function of oracle or such a query which return this result.
Thanks
|
|
|
|
|
Re: Find a break in number sequence [message #359821 is a reply to message #359819] |
Tue, 18 November 2008 04:55   |
S.Rajaram
Messages: 1027 Registered: October 2006 Location: United Kingdom
|
Senior Member |
|
|
Quote: |
i have read the document,but i'm not getting clearly.please reply me a sample query
|
Which bit you are not getting it clearly. Post what you have tried so far. We will take it from there.
Regards
Raj
|
|
|
|