在SQL Server 2005数据库中有如下所示的“学生信息表”stud_inf
15 查阅
SELECT Name FROM stud_info WHERE Birthday>’01/01/1987’AND(Mark<500 OR Mark>560)
SELECT Name FROM stud_info WHERE Birthday>’01/01/1987’AND Mark<500 AND Mark>560
SELECT Name FROM stud_info WHERE Birthday>’01/01/1987’AND Mark<500 OR Mark>560
SELECT Name FROM stud_info WHERE Birthday>’01/01/1987’AND Mark BETWEEN 500 AND 560
参考答案: