ORACLE中排序的时候空值处理
使用关键字:NULLS FIRST,NULLS LAST
空值在前:
SELECT DATA
FROM TABLE
ORDER BY 1 NULLS FIRST
控制在后:
SELECT DATA
FROM TABLE
ORDER BY 1 NULLS LAST
使用关键字:NULLS FIRST,NULLS LAST
空值在前:
SELECT DATA
FROM TABLE
ORDER BY 1 NULLS FIRST
控制在后:
SELECT DATA
FROM TABLE
ORDER BY 1 NULLS LAST