如果有自动编号,假设自动编号的字段名为 AutoID,那么可以第一条记录SELECT TOP 1 AutoID FROM [Table] ORDER BY AutoID ASC最新记录SELECT TOP 1 AutoID FROM [Table] ORDER BY AutoID DESC