摘要:
SELECT s.UNIT_UID AS supplierId, s.UNIT_NAME as supplierName, SUM(IFNULL(d.size, 0)) AS orderNum, SUM(IFNULL(d.sum, 0)) AS orderPrice, SUM(IFNULL(d.re... 阅读全文
摘要:
【Oracle 结论】order by colum asc 时,null默认被放在最后order by colum desc 时,null默认被放在最前nulls first 时,强制null放在最前,不为null的按声明顺序[asc|desc]进行排序nulls last 时,强制null放在最后... 阅读全文