sql - 我想显示大于 20 的工作时间

Question

select fname as 'Employee_Name',sum(hours) as 'Working hours'
from employee e join works_on w on e.ssn = w.essn
group by ssn;

标签： sql

Answer 1

看起来您想要过滤组结果。为此，请使用Havging子句和Group by子句。

我们开工吧：

select fname as 'Employee Name',sum(hours) as 'Working hours'
from employee e join works_on w on e.ssn = w.essn
group by ssn , fname Having sum(hours) > 20;

另请注意，select 子句中使用的列必须存在于 Group By 子句中，但 Group By 子句中的列不必存在于 Select 子句中。