这里取的是日志表里面的数据logid是自动递增的唯一的 StudentId学生id
取日志里面最新的全部记录(建议使用)
select a.*
from tb_l_Student a
inner join (select max(logid) logid from tb_l_Student group by StudentId
)b on b.logid = a.logid
order by a.logId
取日志里面 a.logid,a.StudentId记录(不建议使用)
select a.logid,a.StudentId
from tb_l_Student a,tb_l_Student b
where a.StudentId = b.StudentId
group by a.logid,a.StudentId having a.logId = max(b.logId)
order by a.logId,a.StudentId