- null在前面
#field1与field2同一个字段
ORDER BY NOT ISNULL(field1), field2 ASC|DESC
- null在后面
#field1与field2同一个字段
ORDER BY ISNULL(field1), field2 ASC|DESC
#field1与field2同一个字段
ORDER BY NOT ISNULL(field1), field2 ASC|DESC
#field1与field2同一个字段
ORDER BY ISNULL(field1), field2 ASC|DESC