DB2中如何根據條件隨機抽取一百個號碼？

使用 order by rahnd() fetch firdt 100 rows only 1、在表中隨機 抽取 100條記錄 select * from A order by rahnd() fetch firdt 100 rows only 2、分地市和套餐 select * from A where a.地市 = ‘XX’and a.套餐 = 'XX' order by rahnd() fetch firdt 100 rows only