多项选择题
mybaties中模糊查询like语句的写法（）。
A.select *from foo where bar like #{value}
B.select *from foo where bar like #{%value%}
C.select *from foo where bar like %#{value}%
D.select *from foo where bar like "%"${value}"%"
点击查看答案
相关考题
-
单项选择题
以下（）属于查询班级所有学生并按照年龄升序排序的SQL语句。
A.select *from student group by age
B.select *from student group by age desc
C.select *from student order by age desc
D.select *from student order by age -
单项选择题
以下（）是查询学生记录表中的第3-5条数据。
A.select *from student limit 2，3
B.select *from student limit 2，5
C.select *from student limit 3，5
D.select *from student limit 3，2 -
单项选择题
以下（）属于查询班级所有李姓学生的SQL语句。
A.select *from student where name like’李%’
B.select *from student where name =’李%’
C.select *from student where name like ’%李%’
D.select *from student where name =’李_’
