Printable View
Hi,
please help me
this is my table
create table sequence (
id int not null primary key
);
insert into sequence(id) values
(1), (2), (3), (4), (6), (7), (8), (9),
(10), (15), (16), (17), (18), (19), (20),(22);
i need the answer to group the sequence like this
start_number | end_number | count
1 | 4 | 4
6 | 10 | 5
15 | 20 | 6
22 | 22 | 1
what should i do?
This is homework, isn't it?
There are multiple alternatives to solve this particular scenario, question is... what is your teacher talking about these days, is it grouping? pivoting? unions? analytics?
no no PAVB.
this is a part of my work to make summary report.
But this example is a reproduce data. my data just similar with this case.
thx
On the top of my mind, easiest way will be to create a secondary table describing each range, join both tables grouping by such ranges described in secondary table.