获取表Law_Log中PeopleName字段的最新纪录
WITH tablelist AS (SELECT ROW_NUMBER() OVER (ORDER BY Tmp.LawID DESC) AS Row, * from Law_Log as Tmp where PeopleName = 'GSEGC\sumeihua')
select top 1 * from tablelist order by DoTime Desc
WITH tablelist AS (SELECT ROW_NUMBER() OVER (ORDER BY Tmp.LawID DESC) AS Row, * from Law_Log as Tmp where PeopleName = 'GSEGC\sumeihua')
select top 1 * from tablelist order by DoTime Desc