search

Home >Database >Mysql Tutorial >sql 随机读取记录语句RAND()与newid()

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

WBOY
WBOYOriginal
2016-06-07 17:48:031295browse

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

select * from a order by rand();

mssql newid()

select * from a order by newid;

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：sql 2005 备份数据库.dat或bak还原结构错误的解决方法Next article：生成按日期编码的编码格式 SQL语句

Related articles

See more