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
