What I am trying to do is extract only most recent entries for each unique xNAME. I can't figure out how to do this.Code:SELECT * FROM $dbTable GROUP BY xNAME ORDER BY xDATETIME DESC
SO here is my example table:
john 8:00
greg 9:00
rick 10:00
john 10:15
rick 10:30
greg 11:00
and my desired result is:
john 10:15
greg 11:00
rick 10:30
Is this possible?
