随机提取10条记录的例子: Sqlserver: selecttop10*from表orderbynewid() Access: Selecttop10*FROM表orDERBYRnd(id) Rnd(id)其中的id是自动编号字段,可以利用其他任何数值来完成 比如用姓名字段(UserName) Selecttop10*FROM表orDERBYRnd(len(UserName)) MySql: Select*From表orderByrand()Limit10