单项选择题

A.SELECT *FROM student ORDER BY id DESC LIMIT 1
B.SELECT *FROM student ORDER BY id ASC LIMIT 1
C.SELECT *FROM student LIMIT 1OFFSET (SELECT COUNT(*)FROM student)-1
D.SELECT *FROM student WHERE id =(SELECT MAX(id)FROM student)