摘要:
-- 随机获取 10 条数据SQL Server:SELECT TOP 10 * FROM T_USER ORDER BY NEWID()ORACLE:SELECT * FROM (SELECT * FROM T_USER ORDER BY DBMS_RANDOM.RANDOM()) WHERE RONUM <= 10MySQL:SELECT *FROM T_USER ORDER BY RAND()LIMIT 10Access:SELECT TOP 10 * FROM T_USER ORDER BY rnd([一个自动编号字段])这条语句在 Access 中的“查询”中是可以运行并得到随 阅读全文
posted @ 2014-03-06 10:52
GC2013
阅读(29757)
评论(0)
推荐(1)
浙公网安备 33010602011771号