1. mysql :
SELECT * FROM Member WHERE Country = "HK"ORDERBY RAND() limit 30
2. oracle :
select id from tableName where rownum<100 order by dbms_random.value
本文共 156 字，大约阅读时间需要 1 分钟。
1. mysql :
SELECT * FROM Member WHERE Country = "HK"ORDERBY RAND() limit 30
2. oracle :
select id from tableName where rownum<100 order by dbms_random.value
转载地址：http://vdvkx.baihongyu.com/