摘要: 1 /// <summary> 2 /// 获取对固定列不重复的新DataTable 3 /// </summary> 4 /// <param name="dt">含有重复数据的DataTable</param> 5 /// <param name="colName">需要验证重复的列名</par 阅读全文
posted @ 2017-02-22 15:01 AAABONE 阅读(1080) 评论(0) 推荐(0) 编辑
摘要: 1 select * from( 2 select *,ROW_NUMBER() over(partition by RecordNum order by ID desc)as newrow from T_COM_UserTempModule) as temp where newrow=1 orde 阅读全文
posted @ 2017-02-22 14:40 AAABONE 阅读(454) 评论(0) 推荐(0) 编辑