Postgres Pro
Downloads
Home   >   mailing lists

SQL - histogram - Mailing list pgsql-sql

From msalt@uol.com.br (Txugo)
Subject SQL - histogram
Date
Msg-id 45809a56.0107090919.177def5b@posting.google.com
Whole thread Raw
Responses Re: SQL - histogram  (Mathew White <innards@xmission.com>)
List pgsql-sql
Tree view 
Hi,
I've a problem as follow:
I have a table where one record represent a person, including his height.
I'd like to know how many person have more than 150 cm, more than 160 cm 
and so on.
How can I do that using SQL?

Example:
people > 150 - 1000      > 160 -  850      > 170 -  500      > 180 -  200      > 190 -  30
thanks in advance

pgsql-sql by date:

Previous
From: Stephen Bell
Date:
Subject: Re: sql startment problem PLEASE HELP .....
Next
From: s050399b@hotmail.com (Jacky Cheang)
Date:
Subject: automatic restore of database