给出一个SQL查询语句:SELECT 所属部门,AVG(工资) AS 平均工资 FROM 员工表 WHERE 所属部门 <> “销售部“ GROUP BY 所属部门。语句含义为
A.从员工数据库中检索销售部的平均工资
B.从员工数据库中检索销售部和其他部门的平均工资
C.从员工数据库中检索销售部和其他部门的总工资
D.从员工数据库中检索除了销售部以外其他部门的平均工资
A.从员工数据库中检索销售部的平均工资
B.从员工数据库中检索销售部和其他部门的平均工资
C.从员工数据库中检索销售部和其他部门的总工资
D.从员工数据库中检索除了销售部以外其他部门的平均工资
第1题
A.select deptno,ename,sal from emp a where sal> (select avg(a.sal) from emp where deptno=a.deptno);
B.select deptno,ename,sal from emp a where sal> (select avg(sal) from emp where deptno=a.deptno);
C.select a.deptno,a.ename,a.sal from emp a,emp b where a.deptno=b.deptno and a.sal>avg(b.sal);
D.select a.deptno,a.ename,a.sal from emp a,emp b where a.deptno=b.deptno and b.sal>avg(a.sal);
第2题
A.SELECT Sno, AVG(Grade) FROM SC GROUP BY Sno HAVING AVG(Grade)>=60;
B.SELECT Sno FROM SC WHERE Grade>=60 GROUP BY Sno;
C.SELECT Sno, Grade FROM SC GROUP BY Sno HAVING AVG(Grade)>=60;
D.SELECT Sno FROM SC GROUP BY Sno HAVING Grade >=60;
第3题
第4题
A.String sql="Select * from Student where Sname="+txtName.getText();
B.String sql="Select * from Student where Sname='"+txtName.getText()+"'";
C.String sql="Select * from Student where Sname like "+txtName.getText();
D.String sql="Select * from Student where Sname like '"+txtName.getText()+"'";
第5题
A.职工号
B.姓名
C.部门名
D.工种
第6题
A.SELECT职工号, 姓名FROM职工 WHERE工资= MAX(工资)
B.SELECT职工号, 姓名FROM职工 WHERE工资=(SELECT MAX(工资) FROM职工)
C.SELECT职工号, 姓名, 工资FROM职工 WHERE工资=MAX(工资)
D.SELECT职工号, 姓名,MAX(工资) FROM职工WHERE工资=MAX(工资)
第7题
A.String sql="Select * from Student where Sname="+txtName.getText();
B.String sql="Select * from Student where Sname='"+txtName.getText()+"'";
C.String sql="Select * from Student where Sname like "+txtName.getText();
D.String sql="Select * from Student where Sname like '"+txtName.getText()+"'";
第8题
第9题
第10题
A.Select MAX, MIN, AVG Sage from Student
B.Select MIN, MAX, AVG Sage from Student
C.Select MAX(Sage),MIN(Sage),AVG(Sage) from Student
D.Select MIN(Sage),MAX(Sage),AVG(Sage) from Student
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!