断重复，只保留一条记录，但是要显示全部字段可以直接使用一个SELECT查询筛选出需要的数据：
可以假定第四字段都选值最小的

SELECT [1],[2], [3], Min([4]) AS Min4
FROM 表1
GROUP BY 表1.[1], 表1.[2], 表1.[3];

========================================================

关于移动记录上一条，下一条的问题
select top 1 * from Table1 where ID<request("ID") order by id desc  
select top 1 * from Table1 where ID>request("ID") order by id asc

========================================================

日期条件格式
select * from [table] where [date] > #2003-10-1#  


========================================================

更新数据,模糊查询
update [table] set catalog='pm' where thumb like '*/pm/*'

========================================================

追加数据
INSERT into [table_new](title,content) SELECT title,content FROM [table];