X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 97D9E925B0B for ; Mon, 2 Jun 2003 09:21:11 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 85993-09 for ; Mon, 2 Jun 2003 09:21:00 -0400 (EDT) Received: from irko.smoothcorp.com (unknown [208.49.241.41]) by developer.postgresql.org (Postfix) with ESMTP id 9BD45925A99 for ; Mon, 2 Jun 2003 09:21:00 -0400 (EDT) Received: from jgardner.ifloor.com ([10.0.1.63]) by irko.smoothcorp.com with esmtp (Exim 4.12) id 19MpFC-0007iu-00; Mon, 02 Jun 2003 06:20:58 -0700 Received: from jgardner.ifloor.com (localhost.localdomain [127.0.0.1]) by jgardner.ifloor.com (8.12.8/8.12.8) with ESMTP id h52DKwau030903; Mon, 2 Jun 2003 06:20:58 -0700 Received: from localhost (localhost [[UNIX: localhost]]) by jgardner.ifloor.com (8.12.8/8.12.8/Submit) id h52DKv5h030901; Mon, 2 Jun 2003 06:20:57 -0700 From: Jonathan Gardner Organization: Smooth Corporation To: "listrec" , "Erik G. Burrows" , Subject: Re: SQL problem: bank account Date: Mon, 2 Jun 2003 06:20:56 -0700 User-Agent: KMail/1.5 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200306020620.56966.jgardner@smoothcorp.com> X-SA-Exim-Rcpt-To: listrec@epecon.de, eburrows@erikburrows.com, pgsql-sql@postgresql.org X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: by amavisd-new X-Archive-Number: 200306/22 X-Sequence-Number: 13780 On Monday 02 June 2003 00:49, listrec wrote: > How about: > > select max(transaction_id) from bank_account group by customer_id > And if you want the rest of the data in the rows: SELECT b.* FROM bank_account b JOIN ( SELECT max(transaction_id) AS transaction_id FROM bank_account GROUP BY customer_id ) AS subselect ON subselect.transaction_id=b.transaction_id ; I use a similar query here at work to find the first time a guy has visited our site through an advertiser. -- Jonathan M. Gardner Smooth Corporation - Perl Programmer jgardner@smoothcorp.com - (425) 460-4780 Live Free, Use Linux!