如何使用更新与选择，分组，拥有?

Question

我有这个选择命令

select emp_code, time_date, time_remarks, sum(Tot_hrs) as vTotalHrs 
FROM c04 
WHERE co_code='APPLE'
and time_date>='01-APR-2020' 
group by emp_code, time_date, time_remarks 
having sum(Tot_hrs)>24

使用此选择命令，Time_remarks为 NULL。我想将Time_Remarks更新为特定值。我该怎么做？我试过使用

UPDATE c04 set TIME_REMARKS = '24more' (//above select command) 

但它只是更新了整个表格。有人可以告诉我我哪里出错了吗

Answer 1

这是假设您的emp_code是唯一的ID：

UPDATE    c04
SET       '24more' = time_remarks
WHERE     emp_code IN (select    emp_code
FROM      c04 
WHERE     co_code='APPLE'
and time_date>='01-APR-2020'
AND time_remarks IS NULL
group by  emp_code, 
time_date, 
time_remarks 
having    sum(Tot_hrs)>24)