以下可以正确运行的查询语句有( )
A: select * from user ;
B: select * from user where username =’李四’;
C: select * from user where 1=1;
D: select distinct * from user;
A: select * from user ;
B: select * from user where username =’李四’;
C: select * from user where 1=1;
D: select distinct * from user;
举一反三
- 以下语句哪个是正确的Select查询语句( ) A: select * from use B: select distinct username user; C: select * from user where ; D: select * from user username=’李四’;
- 从数据表中查询用户信息,以下语句中不正确的是( ) 。 A: select<br/>* from user; B: select<br/>username,password from user; C: select<br/>* from user order username; D: select<br/>* from user where username="admin";
- 用户表user中存在一个名字字段username,现查询名字字段中包含"凤"的用户,下列SQL语句中,正确的是() A: select * from user where username = '凤'; B: select * from user where username like '%凤%'; C: select * from user where username like '_凤_'; D: select * from user where username like '凤';
- 【多选题】下面语句可以实现查询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’;
- 下列哪些SQL语句可以查询出User表中name为张三的记录（）。 A: SELECT * FROM User WHERE name = ’张三’ B: SELECT * FROM User WHERE name = ’张三’ LIMIT 0，1 C: SELECT * FROM User WHERE name LIKE ’张三’ D: SELECT * FROM User WHERE name LIKE ’%张三%’