---sql分组后获取其中一个字段最大值或最小值的该行的整条记录----
select * from
(
select ROW_NUMBER() over (partition by ProjectID order by RecordingTime desc) RowID,
ISNULL(TotalNumber,0)TotalNumber,RecordingTime,ProjectID from dbo.AccidentData
where Isvalid=1
and TotalNumber>0
and exists(select 1 from dbo.fnSplit('75,84,20,45,15,46,55,42,41,52,59,57,82,83,16,62,87,86,58',',')P
where ProjectID in (P.col))
) A where A.RowID=1
sql分组后获取其中一个字段最大值或最小值的该行的整条记录
最新推荐文章于 2024-07-19 03:47:42 发布