Lists: | pgsql-sql |
---|
From: | Bob Kruger <bkruger(at)mindspring(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Query Question |
Date: | 1999-06-16 15:01:00 |
Message-ID: | 3.0.5.32.19990616100100.007ac9a0@mindspring.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-sql |
Here is a simple query question that has me stumped.
I have a database that contains the information on vehicle maintenance
costs. When a repair is done to a vehicle, the tag number and the amount
of the repair is recorded.
table structure runs as follows:
id serial
po varchar(12)
veh_no varchar(8)
cost real
comments varchar(30)
I would like to be able to do a query in which I can list all of the
vehicles and a totalization of the costs, e.g. list one vehicle number, and
the sum of costs for that vehicle. Because there are numerous entries for
each vehicle I know that some part of the query will have to include
"distinct veh_no" so that only one output for each vehicle is listed.
I have figured out a way to do this with Perl, but it takes two selects,
and I would prefer to do this with just one.
Any hints or ideas?
Thanks in advance for any assistance.
Regards - Bob Kruger
From: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
---|---|
To: | Bob Kruger <bkruger(at)mindspring(dot)com>, pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] Query Question |
Date: | 1999-06-16 15:19:54 |
Message-ID: | l03130308b38d70ee3be5@[147.233.159.109] |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-sql |
At 18:01 +0300 on 16/06/1999, Bob Kruger wrote:
>
> Here is a simple query question that has me stumped.
>
> I have a database that contains the information on vehicle maintenance
> costs. When a repair is done to a vehicle, the tag number and the amount
> of the repair is recorded.
>
> table structure runs as follows:
>
> id serial
> po varchar(12)
> veh_no varchar(8)
> cost real
> comments varchar(30)
>
> I would like to be able to do a query in which I can list all of the
> vehicles and a totalization of the costs, e.g. list one vehicle number, and
> the sum of costs for that vehicle. Because there are numerous entries for
> each vehicle I know that some part of the query will have to include
> "distinct veh_no" so that only one output for each vehicle is listed.
Do you mean
SELECT veh_no, sum( cost )
FROM the_table
GROUP BY veh_no;
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma