摘要: Access: select top n * from table order by rnd(id)‘id为数据库的自动编号字段 Sql Server: select top n * from table order by newid() MySQL: SELECT * FROM table order by rand() limit 20; Oracle: select * from table order by dbms_random.value() 阅读全文
posted @ 2012-02-08 13:26 pmars 阅读(5736) 评论(0) 推荐(2) 编辑