sql - 是否可以在没有 have 子句的情况下执行此简单查询

Question

SELECT 
    pid, SUM(hourslogged) AS totalhours 
FROM
    flightskills
GROUP BY
    pid
HAVING
    SUM(hourslogged) > 1000

标签： sqloracle

Answer 1

我不知道为什么您having可以摆脱以下内容时专注于该子句join：

select f.pid, sum (f.hourslogged) as Totalhours 
from flightskills f
group by f.pid
having sum(f.hourslogged) > 1000;

如果您真的反对having使用子查询：

select f.*
from (select f.pid, sum (f.hourslogged) as Totalhours 
      from flightskills f
      group by f.pid
     ) f
where Totalhours > 1000;