在线名词解释大全 - SQLServer轻松学 - 详细

在“班级表t_class”中,查询“学生人数”在40~50之间的班级,要求只显示班级编号、班级名称和学生人数。

A
A.SELECT c.class_no, c.class_name, c.stu_numberFROM t_class cWHERE stu_number BETWEEN 40 AND 50
B
B.SELECT c.class_no, c.class_name, c.stu_numberFROM t_class cWHERE c.stu_number BETWEEN 40 AND 50
C
C.SELECT c.class_no, c.class_name, c.stu_numberFROM t_class cWHERE c.stu_number FROM 40 AND 50
D
D.SELECT c.class_no, c.class_name, c.stu_numberFROM t_class cWHERE c.stu_number BETWEEN 40 TO 50
正确答案:
相关推荐
扫描二维码
关注公众平台