ÈçºÎÔÚ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.