subject:"GROUP BY with MAX"

Re: GROUP BY with MAX

2004-05-26 Thread Egor Egorov

Batara Kesuma <[EMAIL PROTECTED]> wrote: > I have a table that looks like: > > mysql> select * from test3; > ++++ > | sub_id | date | data | > ++++ > | 1 | 2004-05-01 | data 001 | > | 1 | 2004-05-02 | data 002

GROUP BY with MAX

2004-05-25 Thread Batara Kesuma

Hi, I have a table that looks like: mysql> select * from test3; ++++ | sub_id | date | data | ++++ | 1 | 2004-05-01 | data 001 | | 1 | 2004-05-02 | data 002 | | 1 | 2004-05-03 | data 003 | | 2 | 2