Unique Row based on date

[snuff]

Hey all,

 

I'm unsure of how to do this any help would be appreciated.

 

Question:

1. how do we get the A1 where column 3 is the most recent date?

 

 

Data:

Column1--Column2-Column3

A1-------Dog-----2001-12

A1-------Dog-----2001-09

A1-------Dog-----2001-08

A1-------Dog-----2001-07

B1-------Dog-----2001-12

B1-------Dog-----2001-11

B1-------Dog-----2001-01

 

 

Result:

Column1--Column2-Column3

A1-------Dog-----2001-12

B1-------Dog-----2001-12

 

Any help would be appreciated

[mikosiko]

use an aggregate function

http://dev.mysql.com/doc/refman/5.6/en/group-by-functions.html

[PFMaBiSmAd]

If you want the specific rows - http://dev.mysql.com/doc/refman/5.5/en/example-maximum-column-group-row.html

[The Little Guy]

You could try this:

 

select * from table order by Column3 desc limit 2

[himmer]

thanks for the replies

 

This worked:

  SELECT Column1, Column2, MAX(Column3) FROM data GROUP By Column1;

[fenway]

You can't do that -- you can't select non-GROUP BY fields that aren't aggregates.  Column2 is likely garbage.