我就廢話(huà)不多說(shuō)了，大家還是直接看代碼吧~

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′