题目内容:
使用SQL语句从表STUDENT中查询所有姓王的同学的信息,正确的命令是:
A.SELECT*FROMSTUDENTWHERELEFT(姓名,2)="王" B.SELECT*FROMSTUDENTWHERERIGHT(姓名,2)="王"
C.SELECT*FROMSTUDENTWHERETRIM(姓名,2)="王"
D.SELECT*FROMSTUDENTWHERESTR(姓名,2)="王"
参考答案:
答案解析: