下面哪条语句可以查询姓“赵”并且年龄等于22岁的用户,请问用哪条语句?( )
A: Select * From tbAddress Where strName="赵" And intAge=22
B: Select * From tbAddress Where strName like "赵%" And intAge="22"
C: Select * From tbAddress Where strName like "赵%" And intAge=22
D: Select * From tbAddress Where strName like "%赵%" And intAge=22
A: Select * From tbAddress Where strName="赵" And intAge=22
B: Select * From tbAddress Where strName like "赵%" And intAge="22"
C: Select * From tbAddress Where strName like "赵%" And intAge=22
D: Select * From tbAddress Where strName like "%赵%" And intAge=22
举一反三
- 要在tbAddress表中更新记录,下面哪条语句是正确的?( ) A: Update tbAddress Set strName="萌萌",intAge=22 Where ID=2 B: Update tbAddress Set strName=萌萌,intAge=22 Where strName=萌萌 C: Update tbAddress Set dtmSubmit=2008-10-1 Where strName="萌萌" D: Update tbAddress Set intAge=18
- 下面哪条语句可以查询姓“张”并且年龄等于20岁的用户，请问用哪条语句？ A: Select * From table Where name like "%张%" And intAge=20 B: Select * From table Where name like "张%" And intAge=20 C: Select * From table Where name like "张%" And intAge="20" D: Select * From table Where name="张" And intAge=20
- 从“学生资料”表中查询所有年龄大于22 岁的学生并显示其姓名,应输入_______命令。 A: SELECT 年龄 FROM 学生资料 WHERE 姓名>22 B: SELECT 年龄 FROM 学生资料 C: SELECT 姓名 FROM 学生资料 WHERE 年龄>22 D: SELECT 姓名 FROM 学生资料
- “员工” 表的“姓名”字段中找出名字包含“玛丽”的人，下面哪条select语句正确：（） A: Select * from员工 where 姓名 =’_玛丽_’ B: Select * from员工 where 姓名 =’%玛丽_’ C: Select * from员工 where 姓名 like‘_玛丽%’ D: Select * from员工 where 姓名 like‘%玛丽%’
- 下列语句（）能够查询所有英语类课程的信息。 A: SELECT * FROM Course WHERE cname LIKE ‘%英语’ B: SELECT * FROM Course WHERE cname LIKE ‘%英语%’ C: SELECT * FROM Course WHERE cname LIKE ‘_英语_’ D: SELECT * FROM Course WHERE cname LIKE ‘*英语*’