环境:postgresql9.5
在order by 语句后添加 nulls first
例:
select product_id,product_name,sale_price,regist_date,
sum (sale_price) over (order by regist_date nulls first) as sum_sale_price
from product
结果:
环境:postgresql9.5
在order by 语句后添加 nulls first
例:
select product_id,product_name,sale_price,regist_date,
sum (sale_price) over (order by regist_date nulls first) as sum_sale_price
from product
结果: