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