问题详情

“从学生关系S中检索姓′王′的学生学号”的SQL语句是
A．SELECT sno FROM sc WHERE sname=′王′
B．SELECT sno FROM sc WHERE sname IS LIKE′王%′
C．SELECT sno FROM sc WHERE sname LIKE′王%′
D．SELECT sno FROM sc WHERE sname LIKE′王_′