隨機提取10條記錄的例子: Sqlserver: selecttop10*from表orderbynewid() Access: Selecttop10*FROM表orDERBYRnd(id) Rnd(id)其中的id是自動編號字段,可以利用其他任何數值來完成比如用姓名字段(UserName) Selecttop10*FROM表orDERBYRnd(len(UserName)) MySql: Select*From表orderByrand()Limit10