# 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