java 小程序

[SLL324]

设有关系EMP（ENO,ENAME,SALARY,DNO）,其中各属性的含义依次为职工号、姓名、工资和所在部门号，以及关系DEPT(DNO,DNANE,MANAGER)，其中各属性含义依次为部门号、部门名称、部门经理的职工号。
a.使用SQL语句完成以下查询：
列出各部门中工资不低于600元的职工的平均工资。
b.请用SQL语句将“销售部”的那些工资数低于600的职工的工资上调10%

[梦_枫]

a:
select dno as '部门号',avg(salary) as '平均工资' form emp where salary > 600 group by dno....

[soulx]

a.

select avg(cur_use)
from EMP
inner join DEPT
on EMP.DNO = DEPT.DNO
where SALARY>=600
gropu by DNO

b.
update EMP set SALARY=SALARY+SALARY*0.1
where ENO in
(select ENO
from EMP
inner join DEPT
on EMP.DNO = DEPT.DNO
where SALARY<600 and DNANE='销售部' )

[soulx]

a.

select avg(salary)
from EMP
where SALARY>=600
gropu by DNO

这样也可以

[梦_枫]

b:
update empt set salary = salary * 0.1 where salary < 600 and dno in (select dno from dept where dname = '销售部')

[qianzhimeiying]

引用 4 楼 zhouyongyang621 的回复:

b:
  update empt  set salary = salary * 0.1 where salary < 600 and dno in (select dno from dept where dname = '销售部')

应该是salary * 1.1

[myeclipse0123]

这个加一个判断语句就可以 了啊

[星辰企业]

A:

select DNANE 部门,AVG(SALARY) 平均工资 FROM EMP,DEPT WHERE SALARY > 600 and EMP.DNO = DEPT.DNO GROUP BY DEPT.DNAME;

B:

UPDATE (SELECT SALARY FROM EMP,DEPT WHERE SALARY < 600 AND EMP.DNO=DEPT.DNO AND DNAME = '销售部')
SET SALARY = SALARY * 1.1;

[sirtener]

据保守估计， 这是老师布置的作业练习题目吧，