emp表: works表: dept表:
题目:查询工资超过他(或她)所在部门预算的20%的雇员
select DISTINCT emp.*
from emp,works,dept
where emp.eid = works.eid and dept.did = works.did and salary>budget*1.2
结果为:
若不加distinct,则结果为
emp表: works表: dept表:
题目:查询工资超过他(或她)所在部门预算的20%的雇员
select DISTINCT emp.*
from emp,works,dept
where emp.eid = works.eid and dept.did = works.did and salary>budget*1.2
结果为:
若不加distinct,则结果为