Re: SQl query

From: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: Abdul Wahab Dahalan <wahab(at)mimos(dot)my>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQl query
Date: 2003-05-07 09:21:47
Message-ID: Pine.LNX.4.44.0305071448110.1048-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

=> select transporttype, count(transporttype) as "#of transport" from
transport group by 1;

regards,
bhuvaneswaran

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 Mendola Gaetano 2003-05-07 09:26:37 Re: pgsql Replication Proxy (was Re: Replication for a
Previous Message DIB Walid 2003-05-07 09:00:04 Re: SQl query