Postgres Pro
Downloads
Home   >   mailing lists

how do i count() similar items - Mailing list pgsql-general

From jackassplus
Subject how do i count() similar items
Date
Msg-id bcdbbc50-fda4-47a8-b7f8-efe3f86bdc98@n19g2000prf.googlegroups.com
Whole thread Raw
Responses Re: how do i count() similar items  (Bill Moran <wmoran@potentialtech.com>)
Re: how do i count() similar items  (Darren Duncan <darren@darrenduncan.net>)
List pgsql-general
Tree view 
lets say I hve the following in the 'fruits' table:

Round orange
Sunkist orange
navel orange
strawberry
blueberry
sunkist orange
apple

how would I get something like the following:

count as c | Fruit type
---------------------------------
4              | orange
2              | berry
1              | apple

pgsql-general by date:

Previous
From: Stefan Wild
Date:
Subject: Re: Empty SELECT result at simultaneous calls
Next
From: Brar Piening
Date:
Subject: Re: Postgres 32bit on Windows 64bit, related components