使用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)="王"