A. SELECT goodsid FROM tb_order WHERE COUNT(goodsid)>1 B. SELECT goodsid FROM tb_order WHERE MAX(goodsid)>1 C. SELECT goodsid FROM tb_order GROUP BY goodsid HAVING COUNT(goodsid)>1 D. SELECT goodsid FROM tb_order WHERE HAVING COUNT(goodsid)>1 GROUP BY goodsid
举一反三
- 订单表tb_order包含用户信息uid和产品信息pid等属性列,以下语句能够返回至少被订购过三次的pid是()。 A: SELECT<br/>pid FROM tb_order WHERE count(pid)>3; B: SELECT<br/>pid FROM tb_order WHERE max(pid)>=3; C: SELECT<br/>pid FROM tb_order GROUP BY pid HAVING COUNT(pid)>3; D: SELECT<br/>pid FROM tb_order GROUP BY pid HAVING COUNT(pid)>=3;
- 以下SQL子句的撰写顺序表达正确的是: A: SELECT、FROM、WHERE、GROUP BY、HAVING、ORDER BY B: SELECT、FROM、WHERE、HAVING、GROUP BY、ORDER BY C: SELECT、FROM、WHERE、ORDER BY、HAVING、GROUP BY D: SELECT、FROM、ORDER BY、WHERE、GROUP BY、HAVING
- 有订单表orders,包含用户信息userid,产品信息productid,以下能够返回至少被订购过两次的productid的SQL语句是()。 A: SELECT productid FROM orders WHERE COUNT(productid)>;1; B: SELECT productid FROM orders WHERE MAX(productid)>;1; C: SELECT productid FROM orders WHERE having COUNT(productid)>;1 GROUP BY productid; D: SELECT productid FROM orders GROUP BY productid HAVING COUNT(porductid)>;1;
- 把查询语句的各个子句按执行的先后顺序排列,正确的是( ) A: FROM→WHERE→GROUP BY→SELECT→ORDER BY B: SELECT→FROM→WHERE→GROUP BY→ORDER BY C: WHERE→FROM→SELECT→GROUP BY→ORDER BY D: FROM→WHERE→SELECT→ORDER BY→GROUP BY
- 若要求“查询选修了3门以上课程的学生的学号”,正确的SQL语句是( ) A: SELECT sNo FROM SC GROUP BY sNo WHERE COUNT(*)> 3 B: SELECT sNo FROM SC GROUP BY sNo HAVING COUNT(*)> 3 C: SELECT sNo FROM SC ORDER BY sNo WHERE COUNT(*)> 3 D: SELECT sNo FROM SC ORDER BY sNo HAVING COUNT(*)> 3
内容
- 0
设数据库中职工表的结构为(职工号,姓名,部门号,出生日期),如果要查询姓名相同的职工信息,则正确的SQL语句是( )。 A: SELECT*FROM职工WHERE姓名IN; (SELECT姓名FROM职工GROUP BY姓名HAVING COUNT(*)>l) B: SELECT*FROM职工WHERE职工号IN; (SELECT职工号FROM职工GROUP BY姓名HAVING COUNT(*)>1) C: SELECT*FROM职工WHERE姓名IN; (SELECT姓名FROM职工GROUP BY职工号HAVING COUNT(*)>1) D: SELECT*FROM职工WHERE职工号IN;(SELECT职工号FROM职工GROUP BY职工号HAVINC COUNT(*)>1)
- 1
统计各系男生人数,最准确的SQL语句是(<br/>)。 A: SELECT<br/>COUNT(*) FROM stduents GROUP BY d_no WHERE sex='男' B: SELECT<br/>COUNT(*) FROM students WHERE sex='男'<br/>GROUP BY d_no C: SELECT<br/>COUNT(*) FROM students WHERE sex='男'<br/>ORDER BY d_no D: SELECT<br/>COUNT(*) FROM students HAVING sex='男'<br/>GROUP BY d_no
- 2
统计每个部门中人数的语句是? A: select count(id) from emp order by deptno; B: select sum(id) from emp order by deptno; C: select count(id) from emp group by deptno; D: select sum(id) from emp group by deptno;
- 3
统计每个部门中的人数的语句是【】。 A: SELECT SUM(ID) FROM examp GROUP BY DE_NUM B: SELECT COUNT(ID) FROM examp ORDER BY DE_NUM C: SELECT COUNT(ID) FROM examp GROUP BY DE_NUM D: SELECT SUM(ID) FROM examp ORDER BY DE_NUM
- 4
检索选课人数少于4人的课程号。正确的SQL语句是( ) A: SELECT CNO FROM SC WHERE COUNT(*)<;4 B: SELECT CNO FROM SC GROUP BY CNO HAVING COUNT(*)<;4 C: SELECT DISTINCT CNO FROM SC ORDER BY CNO D: SELECT CNO FROM SC WHERE COUNT(CNO)<;4