“从学生关系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′王_′