Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8N2Xpe00171 for ; Sat, 22 Sep 2001 22:33:51 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f8N2ID767453 for pgsql-sql@postgresql.org; Sat, 22 Sep 2001 22:18:13 -0400 (EDT) (envelope-from news) From: bulk@colonnello.org (Paolo Colonnello) X-Newsgroups: cz.comp.microsoft.sql, mailing.database.sql-general, comp.databases.ms-sqlserver, comp.databases.postgresql.sql Subject: Simple Query HELP!!! Date: 22 Sep 2001 19:18:10 -0700 Organization: http://groups.google.com/ Lines: 25 Message-ID: Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200109/236 X-Sequence-Number: 4918 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,