Hi
I have a table with this column(ID, stuid, classid,date,status)
The primary key is ID(auto value) and stuid and classid are foreign key.
I want to select the last status registered for each student
select max(ID),stuid, status from table where classID =‘11’ and status= like’I%’
Groupby stuid
And then select the studentname from table join student
What is the right select command?