Re: SQL problem: bank account

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(at)smoothcorp(dot)com - (425) 460-4780
Live Free, Use Linux!