[sqlite] Should this work?

[Matt Young]

# 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