数据库获取随机记录_MySQL

bitsCN.com

数据库获取随机记录

 

随机记录随机数

 

1. mysql :SELECT * FROM Member WHERE Country = "HK" ORDER BY RAND() limit 302. oracle : select id from tableName where rownum<100 order by dbms_random.value

 

bitsCN.com