sql - 有没有办法在 postgresql 中使用 qualify

Question

下面的查询在 teradata 中有效，有没有办法在 postgresql 中编写相同的查询？运行此 ppostgresql 10 时出现错误

select *
from
    product
qualify
    row_number() over (partition by product_key order by product_no) = 1; 

Answer 1

你需要子查询:

select p.*
from (select p.*,
             row_number() over (partition by product_key order by product_no) as seq
      from product p
     ) p 
where seq = 1;