MySQL:
select * from expert e where e.match_Id=107 order by rand() limit 2;
运用order by rand() 对数据进行随机排序,limit取出前两个
SqlService:
select top 2 * from tableName order by newId();
Oracle:
select * from (select * from t order by dbms_random.value) where rownum <2;