当前位置：网站首页>After SQL grouping, get the whole record of the row with the maximum or minimum value of one of the fields

After SQL grouping, get the whole record of the row with the maximum or minimum value of one of the fields

2022-07-20 07:51:00 【Happiness and simplicity 2020】

	---sql After grouping, get the whole record of the row with the maximum or minimum value of one of the fields ----
	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