I am stuck in MySQL query. I have two tables one name is STUDENT and field names is (ID, FullName) where ID is PRIMARY KEY and another table is Student\_FEE field is (ID, Student\_ID, Date) here Student\_ID is foreign key.
When i execute this query i get all the record of but i just want to select only that last row of each Student\_ID not all here is image and query.
Remember I Just Need ID 5 and ID 9 

```
SELECT Student_FEE.*
FROM Student_FEE
LEFT JOIN Student
ON Student_FEE.ID=Student.ID

```

[![enter image description here](https://i.stack.imgur.com/6KZW2.png)](https://i.stack.imgur.com/6KZW2.png)