| From: | "Raj A" <raj(dot)ayappan(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | aggregate query |
| Date: | 2007-05-29 04:32:32 |
| Message-ID: | ddcb1c340705282132p656de07cy5618de275fc1f1f7@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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 NULL DEFAULT,
)
How do i present an aggregate query
inspection_id | meter_id | bay_use
1 12345 (value of bay_1_use)
1 12345 (value of bay_2_use)
1 12345 (value of bay_3_use)
2 23456 (value of bay_1_use)
2 23456 (value of bay_2_use)
2 23456 (value of bay_3_use)
2 23456 (value of bay_4_use)
2 23456 (value of bay_5_use)
Thanks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Kroeger | 2007-05-29 08:04:47 | Re: aggregate query |
| Previous Message | Richard Huxton | 2007-05-25 08:08:31 | Re: group by day |