如何在sqlite中删除前N条记录

没有主键，我只要删除前N条记录。n数值大概在千万级别的。

---

用set rowcount n

---

引用

用set rowcount n

支持

---

SELECT IDD=IDENTITY(INT,1,1),* INTO #T from TB

DELETE #T WHERE IDD NOT IN (SELECT TOP N IDD from #T)

DROP TABLE TB

INSERT TB SELECT * from #T

去除IDD列

---

SQL code:
delete from tb where id in (select top n id from tb)

---

ms不行啊，那位大大给出详细点的代码

---

在线等

---

引用

ms不行啊，那位大大给出详细点的代码

SQL code:
SELECT IDD=IDENTITY(INT,1,1),* INTO #T from TB

DELETE #T WHERE IDD NOT IN (SELECT TOP N IDD from #T)

DROP TABLE TB

INSERT TB SELECT A,B,C,D..... from #T

---

引用

引用 5 楼 y9313 的回复:
ms不行啊，那位大大给出详细点的代码


SQL codeSELECT IDD=IDENTITY(INT,1,1),*INTO #Tfrom TBDELETE #TWHERE IDDNOTIN (SELECTTOP N IDDfrom #T)DROPTABLE TBINSERT TBSELECT A,B,C,D.....from #T

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.