单选题：已知关系student (sno,sname,age,gender,place), 查询姓名中含有”小”字的同学姓名，年龄的

已知关系student (sno,sname,age,gender,place), 查询姓名中含有”小”字的同学姓名，年龄的SQL语句，正确的是（ ）。 @[D
](2)

A. Select sname 姓名,age 年龄 From student Where sname = '小';
B. Select sname 姓名, age 年龄 From student Where sname like '小%';
C. Select sname 姓名, age 年龄 From student Where sname like '_小%';
D. Select sname 姓名, age 年龄 From student Where sname like '%小%';





A.Select sname 姓名,age 年龄 From student Where sname = '小';
B.Select sname 姓名, age 年龄 From student Where sname like '小%';
C.Select sname 姓名, age 年龄 From student Where sname like '_小%';
D.Select sname 姓名, age 年龄 From student Where sname like '%小%';


答案：D