sqlserver、access、mysql随机抽取N条记录

随机抽取10条记录示例：Sqlserver:selecttop10*fromtableorderbynewid()Access:SELECTtop10*FROMtableORDERBYRnd(id)Rnd(id)whereid为自动的number字段可以用任何其他值完成。例如，使用名称字段(UserName)SELECTtop10*FROMtableORDERBYRnd(len(UserName))MySql:Select*FromtableOrderByrand()Limit10