当前位置:数据库 > SQLServer >>

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

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

select * from a order by rand();

mssql newid()

select * from a order by newid;

补充:数据库,Mssql
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,