Re: SQl query

From: Matthew Horoschun <mhoroschun(at)canprint(dot)com(dot)au>
To: wahab(at)mimos(dot)my
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQl query
Date: 2003-05-07 08:34:20
Message-ID: B2A338AD-8066-11D7-9FF5-000393B3A702@canprint.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Abdul,

> How do I make a query so that I get a result like
>
> transporttype | #of transport
> ---------------+-------------
> Lorry | 4
> Pickup | 2

SELECT transporttype, count(*) FROM transport GROUP BY transporttype;

Cheers

Matthew.

In response to

  • SQl query at 2003-05-07 08:20:21 from Abdul Wahab Dahalan

Browse pgsql-sql by date

  From Date Subject
Next Message Victor Yegorov 2003-05-07 08:57:28 Re: SQl query
Previous Message Abdul Wahab Dahalan 2003-05-07 08:20:21 SQl query