# series data looks like:
create table seriesdata (
data_index INTEGER PRIMARY KEY autoincrement,
series_id text,
year numeric,
value numeric);
# and is filled
insert into seriesid
select
s.series_id as id, min(data_index),max(data_index)
from
seriesdata as s
group by
id;
# I intend seriesid to pick up the minand max values of data_index for
each unique series_id
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
