From: msalt@uol.com.br
To: pgsql-sql@postgresql.org
Subject: SQL - histogram
Date: 9 Jul 2001 10:19:49 -0700
Message-ID: <45809a56.0107090919.177def5b@posting.google.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: msalt@uol.com.br
Subject: Re: SQL - histogram
In-Reply-To: <45809a56.0107090919.177def5b@posting.google.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox