X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1663653771 for ; Fri, 15 Apr 2005 12:50:23 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60951-08 for ; Fri, 15 Apr 2005 15:50:20 +0000 (GMT) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by svr1.postgresql.org (Postfix) with ESMTP id 190EF5376A for ; Fri, 15 Apr 2005 12:50:19 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1DMT0s-0007Uc-1f for pgsql-general@postgresql.org; Fri, 15 Apr 2005 17:45:46 +0200 Received: from ppp-82-135-70-161.mnet-online.de ([82.135.70.161]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 15 Apr 2005 17:45:46 +0200 Received: from spam_eater by ppp-82-135-70-161.mnet-online.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 15 Apr 2005 17:45:46 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-general@postgresql.org From: Thomas Kellerer Subject: Re: SQL Question Date: Fri, 15 Apr 2005 17:47:45 +0200 Lines: 10 Message-ID: References: <20050415144200.A1C1C5406F@svr1.postgresql.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: ppp-82-135-70-161.mnet-online.de User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.7.6) Gecko/20050319 Mnenhy/0.6.0.104 X-Accept-Language: de, en In-Reply-To: <20050415144200.A1C1C5406F@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/671 X-Sequence-Number: 76584 jday@gisolutions.us wrote on 15.04.2005 16:42: > select max(lastupdate),prodid > from tablename > group by prodid > Even better :) Thomas