在SQL SRVER中，查询STUDENT1表中GJ大于等于300的男生，则SQL语句应为______
A: SELECT * FROM STUDENT1 WHERE CJ＞300 AND XB="男"
B: SELECT * FROM STUDENT1 WHERE CJ＞=300
C: SELECT * FROM STUDENT1 WHERE CJ＞=300 AND XB="男"
D: 以上都不是
A: SELECT * FROM STUDENT1 WHERE CJ＞300 AND XB="男"
B: SELECT * FROM STUDENT1 WHERE CJ＞=300
C: SELECT * FROM STUDENT1 WHERE CJ＞=300 AND XB="男"
D: 以上都不是
举一反三
- 下面用于查询student表中id值在1,2,3范围内的记录的SQL语句是（ ）。 A: SELECT * FROM student WHERE id=1,2,3; B: SELECT * FROM student WHERE (id=1,id=2,id=3); C: SELECT * FROM student WHERE id in (1,2,3); D: SELECT * FROM student WHERE id in 1,2,3;
- 下面 语句和”select * from student where sex=’男’ && age=20;”语句查询出的结果是一样的。（ ） A: select * from student where sex=’男’ or age=20; B: select * from student where sex=’男’ || age=20; C: select * from student where sex=’男’ and age=20; D: select * from student where sex,age in(’男’,20);
- 数据库中有一张表名称为Student，有列Name，Age，IDCard，Sex。要求查询所有男同学信息，下列哪个SQL语句是正确的 A: Select * From Student Where Sex '男' B: Select * From Student Where Sex ='女' C: Select * From Student Where Sex In '男' D: Select * From Student Where Sex ='男'
- 从Student表检索年龄小于21岁的男学生信息，最规范的SQL语句是( )。 A: Select * From Student Where Ssex='男' Or Sage<'21' B: Select * From Student Where Ssex='男' Or Sage<21 C: Select * From Student Where Ssex=男 And Sage<'21' D: Select * From Student Where Ssex='男' And Sage<21
- 若想查询student表中name为空值的记录，则正确的SQL语句是（ ）。 A: SELECT * FROM student WHERE name = NULL; B: SELECT * FROM student WHERE name like NULL; C: SELECT * FROM student WHERE name = 'NULL'; D: SELECT * FROM student WHERE name is NULL;