Query returning only MAX record

[kirnavi]

I'm trying to write a query that will return only the record that contains the most recent date. For example, if you had a customer database and a new row is added every time the customer makes an order. Now you'd like to see what everyone's most recent orders are.

I'm sure this is simple, but I've been having problems all day.

Thanks!

 

[lespaul]

SELECT * FROM TABLENAME WHERE DATE = (SELECT MAX(DATE) FROM TABLENAME)

something like this should work.


Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!