SQL/PLSQL [message #258620] |
Mon, 13 August 2007 03:45 |
kr_arvind
Messages: 85 Registered: April 2006 Location: Delhi
|
Member |
|
|
Hi,
I need the start number and end number of the series, as per given input. Where the sequence number is break that is end number.
INPUT
Serial_number
1
2
3
4
5
10
11
12
50
51
52
55
56
57
100
OUTPUT
Start_number End_Number
1 5
10 12
50 52
55 57
100
Arvind
|
|
|
|
|
Re: SQL/PLSQL [message #259858 is a reply to message #258651] |
Thu, 16 August 2007 12:59 |
jrich
Messages: 35 Registered: February 2006
|
Member |
|
|
Another solution...
select min(val) seq_start, max(val) seq_end from
(select val from test1 order by val)
group by val-rownum
order by seq_start;
|
|
|