Skip site navigation (1) Skip section navigation (2)

Re: Group by within table joins

From: Jie Liang <jliang(at)ipinc(dot)com>
To: Bernie Huang <bernie(dot)huang(at)ec(dot)gc(dot)ca>
Cc: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Group by within table joins
Date: 2000-09-13 23:28:50
Message-ID: 39C00DB1.F789190@ipinc.com (view raw or flat)
Thread:
Lists: pgsql-sql
Hey,

If you use group then except aggreate functions(count,sum..)
other items in your select list should be in your group list also.

Bernie Huang wrote:

> Hi, I have the following SQL:
>
> SELECT ltb.v_id,
>        count(ltb.v_id) AS num_of_times_borrowed,
>        vtb.equip_attr[1] AS year,
>        vtb.equip_attr[3] AS model,
>        vtb.equip_attr[4] AS type
> FROM log_tb ltb, vehicle_tb vtb
> WHERE ltb.v_id=vtb.equip_id
> GROUP BY ltb.v_id
> ORDER BY year;
>
> "ERROR: Attribute vtb.equip_attr must be GROUPed or used in an aggregate
> function"
>
> but, it didn't work.  I want to know how many time each vehicle has been
> borrowed. Please help.  Thanks.
>
> - Bernie

--
Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.ipinc.com




In response to

pgsql-sql by date

Next:From: Tim QuinlanDate: 2000-09-14 04:57:04
Subject: Web Hosts (off-topic)
Previous:From: Josh BerkusDate: 2000-09-13 23:19:33
Subject: Re: Group by within table joins

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group