Postgres Pro
Downloads
Home   >   mailing lists

Simple Query HELP!!! - Mailing list pgsql-sql

From bulk@colonnello.org (Paolo Colonnello)
Subject Simple Query HELP!!!
Date
Msg-id a27df63d.0109221818.2347f039@posting.google.com
Whole thread Raw
List pgsql-sql
Tree view 
Hello, I have the following, A table call People with 3 fields AGE
(Int) NAME (Txt) COMPANY (TxT) and I want to create a query than get
me a list with the seniors per company, for example :

table PEOPLE

NAME   AGE   COMPANY
Bob     33      Acme
Jane    30      Acme
Bill    20      Acme
Jose    56     ATech
Siu     40     ATech
Paolo   28       IBM
Maria   38       IBM

I need a query than will return a list with the seniors per company
like

Bob
Jose
Maria

Is there a way to do this with one query?

Please help,

pgsql-sql by date:

Previous
From: Haller Christoph
Date:
Subject: Re: is it possible to get the number of rows of a table?
Next
From: nospam4@pobox.com (Ross Smith)
Date:
Subject: A simple join question that may stump you