[Resolved] Query Help - LIMIT question

[Spire2000]

I have a table, we'll call it "status". This table has many rows being entered constantly through user updates. It has many columns, but the two we are concerned with here are a "date" column, and a "group" column.

I'd like to create a query that returns only the most recent entry per group, and ordering the groups alphabetically. I'm racking my brain on this one, but can't figure it out.

The best I can come up with is:

"SELECT * FROM status ORDER BY group DESC LIMIT 1"

But all that does is return one record total, not one record per group. To be clear, each row has a group name entered.

Anyone have any ideas? Any help would be greatly appreciated.

[devinemke]

SELECT group, MAX(date) AS max_date FROM status GROUP BY group ORDER BY goup

[Spire2000]

Excellent! Thanks a ton. This worked exactly as I was hoping for and I was able to extract the required recordsets.

Much appreciated.