Postgres Pro
Downloads
Home   >   mailing lists

SQl query - Mailing list pgsql-sql

From Abdul Wahab Dahalan
Subject SQl query
Date
Msg-id 3EB8C1C5.4745E77E@mimos.my
Whole thread Raw
Responses Re: SQl query  (Matthew Horoschun <mhoroschun@canprint.com.au>)
Re: SQl query  ("Victor Yegorov" <viy@nordlb.lv>)
Re: SQl query  (DIB Walid <walid.dib@inrialpes.fr>)
Re: SQl query  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
List pgsql-sql
Tree view 
If I've a transport table like this:transporttype | transportid
---------------+-------------Lorry         |        1037Pickup        |        1038Lorry         |        1040Lorry
   |        1045Pickup        |        1046Lorry         |        1047
 

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

pgsql-sql by date:

Previous
From: "Ries van Twisk"
Date:
Subject: Re: UNIQUE boolean: only one row may be "true"
Next
From: Matthew Horoschun
Date:
Subject: Re: SQl query