oracle隨機(jī)取若干條數(shù)據(jù) oracle中,怎樣在按照條件選出的數(shù)據(jù)中隨機(jī)選取3條記錄?
oracle中,怎樣在按照條件選出的數(shù)據(jù)中隨機(jī)選取3條記錄?select * from ( select * from tablename where ... order by random.valu
oracle中,怎樣在按照條件選出的數(shù)據(jù)中隨機(jī)選取3條記錄?
select * from ( select * from tablename where ... order by random.value ) where rownum <= 3