49. 使用SQL语句从表STUDENT中查询所有姓王的同学的信息,正确的命令是:( )。(本题2.0分)
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)="王"