获取随机记录
 
随机记录随机数
 
1.  :

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

2. oracle : 

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