Query Question

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
Thread:
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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-06-16 15:12:16 Re: [SQL] Query Question
Previous Message Roland_DUBOULOZ 1999-06-16 14:35:42 date