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
版权声明：本文为xgugu1210原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。