我就廢話不多說了，大家還是直接看代碼吧~

select count(s.*)
from (
select *, row_number() over (partition by fee_date order by fee_date) as gr
from new_order where news_id=’novel’ and order_status=’2′
) s
where s.gr = 1
SELECT count(DISTINCT fee_date) as dis from new_order where news_id=’novel’ and order_status=’2′