设有一个成绩表Student_JAVA(id,name,grade),现需要查询成绩grade第二名的同学信息(假设所有同学的成绩各不相同),正确的SQL语句应该是()。
A.
SELECT*FROM Student_JAVA ORDER BY grade DESC limit 1,1;
B.
SELECT*FROM Student_JAVA ORDER BY grade limit 1,1;
C.
SELECT*FROM Student_JAVA ORDER limit 1,1;
D.
SELECT*FROM Student_JAVA ORDER BY grade DESC limit 0,1;