X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id EDE464763A4 for ; Wed, 7 May 2003 04:20:28 -0400 (EDT) Received: from filter.mimos.my (filter.mimos.my [192.228.137.70]) by postgresql.org (Postfix) with ESMTP id 92B5B47636F for ; Wed, 7 May 2003 04:20:27 -0400 (EDT) Received: from ew.mimos.my (localhost.localdomain [127.0.0.1]) by filter.mimos.my (8.11.6/8.11.6) with ESMTP id h477vjr15770 for ; Wed, 7 May 2003 15:57:45 +0800 Received: (from root@localhost) by ew.mimos.my (8.12.3/8.12.3) id h478KRIT053197 for pgsql-sql@postgresql.org; Wed, 7 May 2003 16:20:27 +0800 (MYT) (envelope-from wahab@mimos.my) Received: from mimos.my (sol-wel197.nat.mimos.my [10.1.23.197]) by ew.mimos.my (8.12.3/8.11.6) with ESMTP id h478KQus052986 for ; Wed, 7 May 2003 16:20:26 +0800 (MYT) (envelope-from wahab@mimos.my) Message-ID: <3EB8C1C5.4745E77E@mimos.my> Date: Wed, 07 May 2003 16:20:21 +0800 From: Abdul Wahab Dahalan Reply-To: wahab@mimos.my Organization: Mimos Berhad X-Mailer: Mozilla 4.77 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: SQl query X-scanner: scanned by Inflex 1.0.10 - (http://pldaniels.com/inflex/) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-3.1 required=5.0 tests=BAYES_20 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/113 X-Sequence-Number: 13278 If I've a transport table like this: transporttype | transportid ---------------+------------- Lorry | 1037 Pickup | 1038 Lorry | 1040 Lorry | 1045 Pickup | 1046 Lorry | 1047 How do I make a query so that I get a result like transporttype | #of transport ---------------+------------- Lorry | 4 Pickup | 2