题目内容
（请给出正确答案）
A.select deptno, max（salary） from emp group by deptn
B.select job, max（salary） from emp group by job having max（salary）>10000
C.select job, max（salary） from emp order by job
D.select job, max（salary） from emp group by salary having max（salary）>10000
答案
AB
如果结果不匹配，请 联系老师 获取答案
更多“下列语句正确的有（）”相关的问题
A.select top 5 from goods order by price desc
B.select top 5 * from goods group by price desc
C.select top 5 * from goods group by price
D.select top 5 * from goods order by price desc
A.CREATE PROCEDURE Myproc () BEGIN SELECT * FROM student; END;
B.CREATE PROCEDURE Myproc () { SELECT * FROM student; }
C.CREATE PROCEDURE Myproc [] BEGIN SELECT * FROM student; END;
D.CREATE PROCEDURE Myproc { SELECT * FROM student; };
A.select ename,job,sal from emp where sal in（select avg（sal） from emp group by deptno）
B.select ename,job,sal from emp where sal in（select min（sal） from emp order by deptno）
C.select ename,job,sal from emp where sal in（select min（sal） from emp group by deptno）
D.select ename,job,min（sal） from emp where sal group by deptno
A.35 35
B.35 36
C.36 35
D.36 36
设教学数据库中，有两个基本表：
学生表：S(S#，SNAME，AGE，SEX)
学习表：SC(S#，C#，GRADE)
现有一个SQL语句：
SELECT SEX，AGE，AVG(GRADE)
FROM S，SC
WHERE S.S# = SC.S#
GROUP BY SEX，AGE
ORDER BY 3 DESC;
试写出与此语句等价的汉语查询语句。
A.GROUPBY出版单位HAVINGCOUNT总编号＞=2
B.GROUPBY出版单位HAVINGCOUNT(DISTINCT总编号)＞=2
C.GROUPBY出版单位＞=2
D.WHERE总编号＞=2
A.SELECT"欢迎"customerName"光临小店"FROMcustomers
B.SELECT'欢迎'customerName'光临小店'FROMcustomers
C.SELECT'欢迎'customerName'光临小店'FROMcustomers
D.SELECT"欢迎"+customerName+"光临小店" FROMcustomers
A.select1,2,3,4,5frominforamation_schema
B.orderby数字
C.通过unionselectnull，增加null的数量逐个去试
D.orderby列名
