如何从表中删除前10行 [英] how to delete top 10 rows from table

问题描述

你好，

如何从表中删除前十行
对此有任何疑问，请通知我.

感谢与问候
vinay

hello,

how to delete top ten row from the table
any query for that,please inform me.

thank & regards
vinay

推荐答案

假设您的tablename具有id列:

Assuming your tablename has an id column :

delete from tablename where id in (select top 10 id from tablename)

尝试这个:

Try this:

DELETE 
FROM dbo.TableName
WHERE Primarykeyfieldname IN
(
	SELECT TOP 10 Primarykeyfieldname
	FROM dbo.TableName
)

希望对您有所帮助:)

hope it helps :)

尝试一下.

Try this.

DELETE TOP(10) FROM table_name

这篇关于如何从表中删除前10行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！