数据库随机取n条记录
摘要：
SQL Server SELECT TOP N * FROM 表名 ORDER BY NEWID() My SQLSELECT * FROM 表名 ORDER BY RAND() LIMIT N OracleSELECT * FROM ( SELECT * FROM 表名 ORDER BY DBMS_RANDOM.VALUE )WHERE ROWNUM < = N; 阅读全文
posted @ 2010-08-06 21:20 周泉 阅读(258) 评论(0) 推荐(1) 编辑