删除Access中的前n条记录 [英] Delete Top n Records in Access
本文介绍了删除Access中的前n条记录的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
你好,
我想从访问表中删除前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屋!
查看全文