随机查询出2条数据
Select sn,a,b From
(Select rownum as sn,s.a as a,s.b as b From ss s Order By dbms_random.value())
Where Rownum < 3
关键语句
dbms_random.value() 随机排序
随机查询出2条数据
Select sn,a,b From
(Select rownum as sn,s.a as a,s.b as b From ss s Order By dbms_random.value())
Where Rownum < 3
关键语句
dbms_random.value() 随机排序