当前位置:Gxlcms > mysql > sql随机读取记录语句RAND()与newid()

sql随机读取记录语句RAND()与newid()

时间:2021-07-01 10:21:17 帮助过:11人阅读

sql 随机读取记录语句rand()与newid()
有人随机函数 rand()

select * from a order by rand();

mssql newid()

select * from a order by newid;

人气教程排行