查找学生表student中姓名的第二个字母为"t"的学生学号sno和姓名sname,下面SQL语句正确的是______。 A.
SELECT sno,sname FROM student WHERE sname LIKE '%t_'; B.
SELECT sno,sname FROM student WHERE sname= '%t_'; C.
SELECT sno,sname FROM student WHERE sname LIKE '_t%'; D.
SELECT sno,sname FROM student WHERE sname='_t%';