Received: from www.base2inc.com (IDENT:root@www.base2inc.com [204.117.190.140]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA30666 for ; Thu, 12 Aug 1999 11:36:44 -0400 (EDT) (envelope-from fmorton@base2inc.com) Received: from tesla (tesla.base2inc.com [206.229.85.131]) by www.base2inc.com (8.8.7/8.8.7) with SMTP id KAA31567 for ; Thu, 12 Aug 1999 10:44:33 -0500 Message-ID: <00ef01bee4da$8d704060$8355e5ce@base2inc.com> From: "Frank Morton" To: References: <003401bee4d3$42774e20$0200a8c0@mike> <37B2E714.DB904C2B@bart.w-wa.pl> Subject: Select Maximum Question Date: Thu, 12 Aug 1999 10:51:33 -0500 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 I am a SQL newbie, so hang in there with me. I have two fields in a table, "filename" and "revision". The table contains 3 rows where the filename is the same and revision contains "1" "2" and "3" in each respective row. It also contains another row for a different filename with revision set to "1". I want to do a select which only returns the highest revision level for each filename, so the select will return two rows, the first filename with revision = "3" and the second filename with revision set to "1". How do I do this? I imagine this is simple, but it is new to me. Thanks.