获得最新纪录 sql
摘要：获取表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 orde...
阅读全文
posted @
2007-10-31 16:29
sumh
阅读(178)
推荐(0) 编辑
昵称：
