从表中随机的取数据,有些应用场景会需要,比如考试的抽题目、或者网站中做个小功能‘随便看看’之类的
SQL SERVER用法:
1
|
SELECT * from tablename ORDER BY NEWID()
|
MySQL用法:
1
|
SELECT * from tablename ORDER BY RAND()
|
从表中随机的取数据,有些应用场景会需要,比如考试的抽题目、或者网站中做个小功能‘随便看看’之类的
SQL SERVER用法:
1
|
SELECT * from tablename ORDER BY NEWID()
|
MySQL用法:
1
|
SELECT * from tablename ORDER BY RAND()
|