SQL max and date trouble

[tridith]

I have one table, (table1).
Fields (date, asset_id, and location)..*and some other ones*

I want to get the most resent date and the location on that date, for each asset_id.

I was trying to use a MAX() on the date, in combination with a distinct on the asset_id. It didnt work.

How do I do this?

So for each distinct asset_id, i want to get its latest date.

Thanks.

Chad

 

[tridith]

Where would the correct forum be????

 

[PHV]

Where would the correct forum be?
Have a look here:

http://www.tek-tips.com/threadforum.cfm?lev3=27

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886