数据库中有一张表名称为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 ='男'

订单表tb_order包含用户信息uid和产品信息pid等属性列,以下语句能够返回至少被订购过三次的pid是()。 A: SELECT<br/>pid FROM tb_order WHERE count(pid)&gt;3; B: SELECT<br/>pid FROM tb_order WHERE max(pid)&gt;=3; C: SELECT<br/>pid FROM tb_order GROUP BY pid HAVING COUNT(pid)&gt;3; D: SELECT<br/>pid FROM tb_order GROUP BY pid HAVING COUNT(pid)&gt;=3;

查询选修了2门课程以上的学生学号（） A: select sid,count(*) from sc group by sid having count(*)>=2 B: select sid,count(*) from sc group by sid where count(*)>=2 C: select sid,count(*) from sc where count(*)>=2 group by sid D: select sid,count(*) from sc group by cid having count(*)>=2

查询学生的姓名、出生年月,最准确的SQL语句是(<br/>)。 A: SELECT<br/>* FROM students B: SELECT<br/>s_name,birthday FROM students C: SELECT<br/>s_name,birthday,phone FROM students D: SELECT<br/>s_name,birthday FROM students ORDER BY birthday

基于“学生-选课-课程”数据库中的三个关系: 学生表S(SNO,SNAME,SEX,BIRTHYEAR,DEPT),主码为SNO 课程表C(CNO,CNAME,TEACHER),主码为CNO 选课表SC(SNO,CNO,GRADE),主码为(SNO,CNO) [br][/br]查找“选修了至少5门课程的学生的学号”,正确的SQL语句是( )。 A: SELECT SNO FROM SC GROUP BY SNO HAVING COUNT(*) >=5; B: SELECT SNO FROM SC GROUP BY SNO WHERE COUNT(*) >=5; C: SELECT SNO FROM SC HAVING COUNT(*) >=5; D: SELECT SNO FROM SC WHERE COUNT(*) >=5;