SELECT IDD=IDENTITY(INT,1,1),* INTO #T FROM TB DELETE #T WHERE IDD NOT IN (SELECT TOP N IDD FROM #T)DROP TABLE TBINSERT TB SELECT * FROM #T 去除IDD列
delete from tb where id in (select top n id from tb)
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
SELECT IDD=IDENTITY(INT,1,1),* INTO #T FROM TB DELETE #T WHERE IDD NOT IN (SELECT TOP N IDD FROM #T) DELETE TB INSERT TB SELECT * FROM #T
弄错了,是DELETE不能是DROP
我个人思路,先查出前N条记录,然后在删除! SELECT TOP 10 * FROM table WHERE (ID NOT IN (SELECT TOP 10 ID FROM table))二:在删除:delete from (SELECT top 10 * FROM dbo.table WHERE (NID NOT IN (SELECT TOP 10 NID FROM dbo.table)))
SET ROWCOUNT 3 --把3改成你要删除的条数 delete from tbSET ROWCOUNT 0
我的也可以换种思路,删除指定行!SELECT TOP 1 * FROM AssoInfo2 WHERE (ID NOT IN (SELECT TOP 2 ID FROM AssoInfo2)),此句指向第三行
---2005的用法 set rowcount ndelete * from tbset rowcount 0
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
SELECT IDD=IDENTITY(INT,1,1),* INTO #T FROM TB DELETE #T WHERE IDD NOT IN (SELECT TOP N IDD FROM #T) DELETE TB INSERT TB SELECT * FROM #T
SELECT TOP 10 *
FROM table WHERE (ID NOT IN
(SELECT TOP 10 ID
FROM table))二:在删除:delete from (SELECT top 10 *
FROM dbo.table
WHERE (NID NOT IN
(SELECT TOP 10 NID
FROM dbo.table)))
SET ROWCOUNT 3 --把3改成你要删除的条数
delete from tbSET ROWCOUNT 0
FROM AssoInfo2
WHERE (ID NOT IN
(SELECT TOP 2 ID
FROM AssoInfo2)),此句指向第三行
set rowcount ndelete * from tbset rowcount 0
2000去掉*试下
delete from tb
rowcount 的方法似乎行不通的
SQLite error
near "(": syntax error
所以正在一个一个方法的试
改成limit 10