Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA16593 for ; Thu, 12 Aug 1999 19:02:58 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id TAA22980; Thu, 12 Aug 1999 19:01:56 -0400 (EDT) To: "Frank Morton" cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Select Maximum Question In-reply-to: Your message of Thu, 12 Aug 1999 10:51:33 -0500 <00ef01bee4da$8d704060$8355e5ce@base2inc.com> Date: Thu, 12 Aug 1999 19:01:56 -0400 Message-ID: <22978.934498916@sss.pgh.pa.us> From: Tom Lane "Frank Morton" writes: > I want to do a select which only returns the highest revision > level for each filename, Try something like SELECT filename, max(revision) FROM table GROUP BY filename; When you use GROUP BY, aggregate functions like max() are applied separately over each group --- which is just what you want for this problem. regards, tom lane