生成指定范围“800~900”的10条随机数据:
SELECT num FROM generate_series ( 800, 900 ) AS t ( num ) ORDER BY random ( ) LIMIT 10
查询结果如下图所示:
生成指定范围“800~900”的10条随机数据:
SELECT num FROM generate_series ( 800, 900 ) AS t ( num ) ORDER BY random ( ) LIMIT 10
查询结果如下图所示: