标题: SQL查询时去除重复值 [打印本页]

---

作者: erina.pan    时间: 2017-5-2 11:14     标题: SQL查询时去除重复值

方法1：  delete from test  where id not in (select max(id) from test with(nolock) group by bookname,nuthor having count(id) > 0)

方法2：WITH myd AS
(
    SELECT ROW_NUMBER()
    OVER(PARTITION BY bookname,nuthor ORDER BY ID )
    AS NUM,* FROM test
)
DELETE FROM myd
WHERE NUM != 1

---

欢迎光临 赛捷软件论坛 (http://sagesoft.cn/bbs/)

Powered by Discuz! 7.2