一起答
单选

(29)使用SQL语句从表STUDENT中查询所有姓王的同学的信息,正确的命令是:

  • A)SELECT*FROM STUDENT WHERE LEFT(姓名,2)=“王”
  • B)SELECT*FROM STUDENT WHERE RIGHT(姓名,2)=“王”
  • C)SELECT*FROM STUDENT WHERE TRIM(姓名,2)=“王”
  • D)SELECT*FROM STUDENT WHERE STR(姓名,2)=“王”
参考答案
查看试卷详情