- 搜标题
- 搜题干
- 搜选项
单项选择题
有学生表Student(S# char(8), Sname char(10), Ssex char(2),Sage integer, D# char(2), Sclasschar(6))。若要“检索名字为张某某的所有同学姓名”，SQL语句正确的是_________。
A、Select Sname From Student Where Sname Like ‘张____’;
B、Select Sname From Student Where Sname Like ‘张%’;
C、Select Sname From Student Where Sname Like ‘张_’;
D、Select Sname From Student Where Sname Not Like ‘张_ _’;
B、Select Sname From Student Where Sname Like ‘张%’;
C、Select Sname From Student Where Sname Like ‘张_’;
D、Select Sname From Student Where Sname Not Like ‘张_ _’;
你可能感兴趣的试题
