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 | 2004-06-01 | data 2 001 |
| 2 | 2004-06-02 | data 2 002 |
| 2 | 2004-06-03 | data 2 003 |
+--------+------------+------------+
6 rows in set (0.00 sec)
If I group it by sub_id this is what I get:
mysql> select * from test3 group by sub_id;
+--------+------------+------------+
| sub_id | date | data |
+--------+------------+------------+
| 1 | 2004-05-01 | data 001 |
| 2 | 2004-06-01 | data 2 001 |
+--------+------------+------------+
2 rows in set (0.01 sec)
I want to get the data from the MAX(date) grouped by sub_id, the result
I want is:
+--------+------------+------------+
| sub_id | date | data |
+--------+------------+------------+
| 1 | 2004-05-03 | data 003 |
| 2 | 2004-06-03 | data 2 003 |
+--------+------------+------------+
How can I do that?
Thanks,
Batara
