Re: [SQL] Comparing two slices within one table efficiently

2007-08-13 Thread Andrew Kroeger
Ken Simpson wrote: > I have a table with the following simplified form: > > create table t ( > run_id integer, > domain_id integer, > mta_id integer, > attribute1 integer, > attribute2 integer, > unique(run_id, domain_id, mta_id) > ); > > The table has about 1 million rows with run_id=1, an

Re: [SQL] aggregate query

2007-05-29 Thread Andrew Kroeger
Raj A wrote: > I have a table > > CREATE TABLE survey_load > ( > meter_id character(5) NOT NULL, > number_of_bays integer NOT NULL, > bay_1_use integer, > bay_2_use integer, > bay_3_use integer, > bay_4_use integer, > bay_5_use integer, > date date NOT NULL, > inspection_id integer NOT NU