---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