03 2017 档案

SQL SERVER常用的统计用法
摘要：--查询各个状态下总数SET statistics time on Go SELECT sum(CASE WHEN [Status] =-1 THEN 1 ELSE 0 END ) AS Q1, sum(CASE WHEN [Status] =0 THEN 1 ELSE 0 END ) AS Q2, sum(CASE WHEN [Status] =1 THEN 1 ELSE 0 END ) A... 阅读全文
posted @ 2017-03-28 12:55 曾俊杰 阅读(564) 评论(0) 推荐(0) 编辑