SQL SERVER开窗函数DEMO
摘要:
1-统计版本数量 SELECT COUNT ( T1.id ) OVER () AS total, T1.* FROM DIM_EDITION_THREE T1 2-统计不同类型版本的数量 SELECT COUNT ( T1.id ) OVER (PARTITION BY T1.fn_status) 阅读全文
posted @ 2022-07-12 11:28 -韩帅 阅读(73) 评论(0) 推荐(0) 编辑