学无先后,达者为师

网站首页 Thinkphp 正文

thinkphp 数据库随机取出N条数据方法(Oracle-MySQL-SQL Server)

更新时间: 2022-07-30 Thinkphp

Oracle:

select * from (select * from table_name order by dbms_random.random()) where rownum <=10

MySQL:

SELECT * FROM TABLE_NAME  ORDER BY  RAND() LIMIT 10

ThinkPHP:
Db::table('table_name')->orderRaw("RAND()")->limit(10)->select();

SQL Server:

SELECT TOP 10 * FROM TABLE_NAME ORDER BY NEWID()


栏目分类
最近更新