pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (3+ messages)  latest in thread

Message-ID: <45809a56.0107090919.177def5b@posting.google.com>
Permalink:  ../45809a56.0107090919.177def5b@posting.google.com/
Also on:    postgresql.org/message-id/45809a56.0107090919.177def5b@posting.google.com

 · 

reply

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