Simple Query HELP!!!

From: bulk(at)colonnello(dot)org (Paolo Colonnello)
To: pgsql-sql(at)postgresql(dot)org
Subject: Simple Query HELP!!!
Date: 2001-09-23 02:18:10
Message-ID: a27df63d.0109221818.2347f039@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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,

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bob Barrows 2001-09-23 03:12:12 Re: Simple Query HELP!!!
Previous Message Stephan Szabo 2001-09-22 16:49:19 Re: more information on JOINs