删除Access中的前n条记录 [英] Delete Top n Records in Access

问题描述

你好，

我想从访问表中删除前10条记录.
有人告诉我查询要删除Access 2007中的前10条记录.

我在下面尝试过-

Hello There,

I want to delete top 10 records from my access table.
Does anyone tell me query to delete top 10 records in access 2007.

I have tried below -

Delete Top 10 * from FROM Activity_Master;

但我在顶部"出现语法错误.

请帮忙！

but I am getting Syntax Error at "Top".

Please help!!!

推荐答案

尝试

Delete from Activity_master
where ID in (select top 10 ID from activity_master)

(其中ID是您的ID字段)

(where ID is your id field)

您可以尝试以下代码:

Could you try the below code:

DELETE * FROM Activity_Master
WHERE IDField IN
(SELECT TOP 10 X.IDField
FROM Activity_Master AS X

这篇关于删除Access中的前n条记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！