Salesforce的soql排序时,Null值排序问题
- How to sort null values at last in SOQL?
Generally in SOQL, null values are sorted first. In order to sort null values at last make use of NULLS LAST keyword.
Sample SOQL:
SELECT Id, Name, Industry
FROM Account
ORDER BY Industry DESC NULLS LAST
**在每个需要DESC降序排序的字段后面加上NULLS LAST就可以实现null值排在最后面 **