sql分类汇总及Select的自增长脚本
- WBOYOriginal
- 2016-06-07 18:07:04826browse
对错误信息进行分类汇总,并实现错误数据的自增长编号
如图:其中Num是自增长列,Operation是分类标签,count是汇总数据
脚本如下:
代码如下:
select Num=row_number() OVER(order BY HT_Resv.OperationStatus),HT_Resv.OperationStatus ,
CASE HT_Resv.OperationStatus
WHEN '3' THEN '成功'
WHEN '4' THEN '失败'
end as 'Status',count(HT_Resv.Id) as 'Count'
FROM ht_resv group BY HT_Resv.OperationStatus
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：SQLServer中用T—SQL命令查询一个数据库中有哪些表的sql语句Next article：SQL Server 作业的备份(备份作业非备份数据库)