oracle-高级查询

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.—
待补充