DB2 9.5 . Select distinct values from first column , but seeing 2 other coluns values
Hi I have a single table with 80,000+ rows (tag feeds) of which I have 12 distinct tags.(TagID) so I only want to return 12 rows.

I want to find the latest value for each tagid based on the (MAX) date field. So really I want a DISTINCT on the tagid and make sure I have the record for the newest date and display the tagid,date and location fields
DB2 9.5 . Select distinct values from first column , but seeing 2 other coluns values
===

Hi I have a single table with 80,000+ rows (tag feeds) of which I have 12 distinct tags.(TagID) so I only want to return 12 rows.

I want to find the latest value for each tagid based on the (MAX) date field. So really I want a DISTINCT on the tagid and make sure I have the record for the newest date and display the tagid,date and location fields