数据库获取随机记要

数据库获取随机记录

1. mysql :

SELECT * FROM MemberWHERE Country = "HK"ORDER BY RAND() limit 30

2. oracle : 

select id from tableName where rownum<100 order by dbms_random.value