05 2015 档案

sqlserver查询某一字段重复超5次的所有记录
摘要：用的sqlserver2008 r2。SELECT*FROM t_classWHERE idIN (SELECTidFROM (SELECTROW_NUMBER() OVER (PARTITION BY id ORDER BY inserttime) AS rn,idFROM t_class) my... 阅读全文
posted @ 2015-05-18 12:00 影月千夜 阅读(1572) 评论(0) 推荐(0) 编辑