在sql server中,從數(shù)據(jù)表中隨機(jī)取出n條記錄,使用以下SQL語句:
select top n * from tableName order by newid()
在oralce中,從數(shù)據(jù)表中隨機(jī)取出n條記錄,使用以下SQL語句
select * from (select tableName .*,dbms_random.random as randomKey from tableName order by randomKey)
where rownum<=n
Let life be beautiful like summer flowers and death like autumn leaves.