delete guestdata
from (select top 2 * from guestdata) as t1
where guestdata.key=t1.key或者:
set rowcount 2
delete guestdata
set rowcount 0
from (select top 2 * from guestdata) as t1
where guestdata.key=t1.key或者:
set rowcount 2
delete guestdata
set rowcount 0
where id in (select top 2 id from guestdata)
是了,为什么还要加上AS T1呢!
where id in (select top 2 ID from guestdata)
from(select top 2 * from guestdata) as t1>>>結果將為DELETE guestData
From
guestData
CROSS JOIN
(Select Top 2 * from guestData) as t1當然會刪除你整個表了!!!!
delete [guestdata]
where id in (select top 2 id from [guestdata])
由于可以在 DELETE 语句中指定 SELECT 语句,因此还可以在 SELECT 语句中使用 TOP 子句。例如,下例从 authors 表中删除前 10 个作者。
DELETE authors
FROM (SELECT TOP 10 * FROM authors) AS t1
WHERE authors.au_id = t1.au_id