I know this post is a few yeyars old, but I need help on this same topic.
I have a mysql table with student test scores in it.
Some of the fields are as follows:
I need to pull all the totals, BUT only for DISTINCT AssessID's.
In other words, if more than one scores exists for a student for the same test, only pull the LAST score entered.
SELECT DISTINCT AssessID From Table WHERE blabla='blabla' ORDER BY ID DESC ~ won't let me pull the Total.
And SELECT * FROM table WHERE blabla='blabla' GROUP BY AssessID ~ only selects the first record instead of the latest
Any help would be appreciated. Thanks!