select * from (
SELECT
*
FROM
`xb_temperature`

ORDER BY time desc LIMIT 18446744073709551615

) a GROUP BY student_id ;