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
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
转载于:https://www.cnblogs.com/james1207/p/3357932.html