oracle substr
SELECT head.fcust_party_id,count(1)
FROM 表名 head
WHERE
to_date(substr(head.fcreate_date,1,10),'yyyy-mm-dd') >=to_date('2017-01-01','yyyy-mm-dd')
group by head.fcust_party_id
order by count(1) desc
SELECT head.fcust_party_id,count(1)
FROM 表名 head
WHERE
to_date(substr(head.fcreate_date,1,10),'yyyy-mm-dd') >=to_date('2017-01-01','yyyy-mm-dd')
group by head.fcust_party_id
order by count(1) desc