Oracle:

       select * from (select * from tableName order by dbms_random.value) where rownum < N;


MS SQLServer:

       select top N * from tableName order by newid();

 

My SQL:

       select * from tableName order by rand() limit N;



转自：http://blog.csdn.net/senton/article/details/4404101