sfsdaf444(提问者) 回复 Z4u3z1SELECT ID, Equipment AS 设备类型, Channel AS 通道, SN AS 条码, StartTime AS 启动时间, EndTime AS 结束时间,
DischargeTime AS 放电时长, OpenVoltage AS 开路电压, TerminationVoltage AS 终止电压, MedianVoltage AS 中值电压, CreateDate AS 上传时间,
(SELECT ROW_NUMBER() OVER (ORDER BY ENDTIME DESC,SN,COUNT(*)) AS Expr1
from dbo.Discharge
WHERE (SN = A.SN )) AS 放电次数
FROM dbo.Discharge AS A
WHERE SN=\'CE4AWH2321018F2\'
ORDER BY EndTime DESC
===============================
SELECT ROW_NUMBER() OVER (ORDER BY ENDTIME DESC,SN) AS Expr1,COUNT(*)
FROM dbo.Discharge
WHERE SN=\'CE4AWH2321018F2\'
GROUP BY EndTime,SN