select count(1) over(partition by date) from tablename
等价于
select count(1),date from tablename group by date
select asofdate from tablea
except
select asofdate form tableb
返回存在于a表而不存在于b表的asofdate
select count(1) over(partition by date) from tablename
等价于
select count(1),date from tablename group by date
select asofdate from tablea
except
select asofdate form tableb
返回存在于a表而不存在于b表的asofdate