时间:2021-07-01 10:21:17 帮助过:40人阅读
-------------------------------------------------------------------------------- view plaincopy to clipboardprint?
select * from tablename order by rand() limit 10
select * from tablename order by rand() limit 10sqlserver中随机提取数据库记录
-------------------------------------------------------------------------------- view plaincopy to clipboardprint?
select top 10 * from tablename order by NEWID()
select top 10 * from tablename order by NEWID()Access中随机提取数据库记录
-------------------------------------------------------------------------------- view plaincopy to clipboardprint?
SELECT top 10 * FROM tablename ORDER BY Rnd(FId)
SELECT top 10 * FROM tablename ORDER BY Rnd(FId)FId:为你当前表的ID字段名