1.随机返回n条数据
select * from (select a from table order by dbms_random.value()) where rownum <= n;
2.空值的排序
select * from table order by a desc nulls last/first
--空值排在最后/前面
3.—
待补充
1.随机返回n条数据
select * from (select a from table order by dbms_random.value()) where rownum <= n;
2.空值的排序
select * from table order by a desc nulls last/first
--空值排在最后/前面
3.—
待补充