首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > 其他数据库 >

数据库 随机 提取 N条记要

2012-09-08 
数据库 随机 提取 N条记录随机取出n条记录:mysql:Select * From tablename order By rand() Limit n SqlSe

数据库 随机 提取 N条记录
随机取出n条记录:

mysql:

    Select * From tablename order By rand() Limit n 

SqlServer:
    select top n * from tablename order by newid()

Access:
    Select top n * FROM tablename orDER BY Rnd(id)

Oracle:
    Select * from (select * from tablename order by sys_guid()) where rownum < n    Select * from (select * from tablename order by dbms_random.value) where rownum < n

DB2:
    Select * from tablename order by rand() fetch first n rows only

热点排行