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