如何删除满足条件的前N条记录

[Nintendo_hc]

比如满足删除条件的记录有10万条，但我只需要删除其中的前100条（按时间顺序）
请教这个SQL语句应该如何写

[NBDBA]

2005+

delete (top 50)
tablename
where ...

[jalor_6]

顶一顶，更健康

[中国风]

IF (SELECT COUNT(*) FROM table1)>=100000
BEGIN
	SET ROWCOUNT 100
	DELETE table1
	SET ROWCOUNT 0
END

[中国风]

判斷是否有10W條，再刪除

[--小F--]

;with f as
(
select id=row_number()over(order by 时间字段),* from tb
)
delete from f where id<=100

[-晴天]

delete from tb where 条件 and 时间 in(select top 100 时间 from tb where 条件 order by 时间)

[Nintendo_hc]

[Quote=引用 1 楼 nbdba 的回复:]
2005+


SQL code

delete (top 50)
tablename
where ...
[/Quote]

我这样写的
delete (top 50) 表1 where time <10

提示 '(' 附近有语法错误

[geniuswjt]

--nbdba大哥在坑你，这样
delete top (50)
tablename
where ...

[Quote=引用 7 楼 nintendo_hc 的回复:]
引用 1 楼 nbdba 的回复:
2005+


SQL code

delete (top 50)
tablename
where ...


我这样写的
delete (top 50) 表1 where time <10

提示 '(' 附近有语法错误
[/Quote]

[jxjdzwang5555]

delete (top 50) from 表1 where time <10

[huangmf_c]

delete (top 50)
tablename
where ...