SELECT * FROM ( SELECT * FROM table_name WHERE xxx ORDER BY DBMS_RANDOM.random) WHERE ROWNUM <= (select count(1)/2+1 from table_name) 看看这个满足不
SELECT * FROM ( SELECT * FROM table_name WHERE xxx ORDER BY DBMS_RANDOM.random) WHERE ROWNUM <= (select count(1)/2+1 from table_name)
17,140
社区成员
55,259
社区内容
加载中
试试用AI创作助手写篇文章吧