问题详情

从数据表 student 中查询张姓的所有学生，正确的 SQL语句是()。
A.SELECT sno,sname FROM student WHERE sname LIKE N" 张%"
B.SELECT sname FROM student WHERE sname = N"% 张%"
C.SELECT sno,sname FROM student WHERE sname LIKE N"% 张%"
D.SELECT sname FROM student WHERE sname = N" 张%"