The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 |
Newsgroups: comp.databases.oracle.misc
From: "Michel Cadot" <micadot{at}altern{dot}org>
Date: Sat, 21 Oct 2006 18:44:19 +0200
Local: Sat, Oct 21 2006 12:44 pm
Subject: Re: Reduce To Ranges aggregate function
"Dieter Noeth" <dno...@gmx.de> a écrit dans le message de news: ehdhat$sc...@online.de... | Mike King wrote: | | > ID | > ---- | > 1 | > 2 | > 3 | > 4 | > 5 | > 11 | > 12 | > 45 | > | > Reduced form: 1-5,11-12,45 | | Consecutive values are easy to find using OLAP-functions: | | select | min(id), max(id) | from | ( | select | id, | id - row_number() over (order by id) grp | from t | ) dt | group by grp | | If id is not unique use dense_rank instead of row_number... | | Dieter Neat solution! Regards You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||