下面语句可以实现查询user表中“zhangsan”的user,password,logins信息的是
A、select logins,user,password from user where name like ’%zhangsan%’;
B、select user,password,logins, from user where name like ’zhangsan’;
C、select password,logins,user from user where name=’zhangsan’ limit 1;
D、select user,password,logins from user where name=’zhangsan’;