10 2016 档案

sql 更新重复数据只取一条记录
摘要：select s.* from ( select *, row_number() over (partition by PersonnelAccount order BY PersonnelID) as group_idx from AUX_SpecialPersonnel ) swhere s.g 阅读全文
posted @ 2016-10-11 19:23 renzaijianghu 阅读(2728) 评论(0) 推荐(0) 编辑