order by 对null的处理

【Oracle 结论】 
order by colum asc 时，null默认被放在最后
order by colum desc 时，null默认被放在最前
nulls first 时，强制null放在最前，不为null的按声明顺序[asc|desc]进行排序
nulls last 时，强制null放在最后，不为null的按声明顺序[asc|desc]进行排序 
【MySql 结论】
order by colum asc 时，null默认被放在最前
order by colum desc 时，null默认被放在最后
ORDER BY IF(ISNULL(update_date),0,1) null被强制放在最前，不为null的按声明顺序[asc|desc]进行排序
ORDER BY IF(ISNULL(update_date),1,0) null被强制放在最后，不为null的按声明顺序[asc|desc]进行排序

		SELECT s.unit_uid as supplierId,s.UNIT_NAME as supplierName,IFNULL(m.orderNum, 0) as orderNum,IFNULL(m.orderPrice, 0) as orderPrice,
		IFNULL(m.receiveNum, 0) as receiveNum ,IFNULL(m.receivePrice, 0) as receivePrice
		FROM bas_supplier s LEFT JOIN (
		SELECT
			b.supplier_uid AS supplierId,
			SUM(IFNULL(d.size, 0)) AS orderNum,
			SUM(IFNULL(d.sum, 0)) AS orderPrice,
			SUM(IFNULL(d.receive, 0)) AS receiveNum,
			SUM(
				IFNULL(d.receive, 0) * IFNULL(d.price, 0)
			) AS receivePrice
		FROM 
		pchs_bill b 
		LEFT JOIN pchs_detail d ON b.bill_uid = d.bill_uid
		WHERE b.com_uid = #comUid#
		
			and b.status  in #status[]:Integer#
		
		
			= #startDate#]]>
		
		
			
		
		 b.storage_uid = #storageId#  
		
			 #multi_storage_uid[]# 
		
		GROUP BY
			b.supplier_uid
		) m ON m.supplierId=s.unit_uid
		
		WHERE s.unit_uid =#supplierId#
		
		order by IF(ISNULL(orderNum),1,0),orderNum DESC,IF(ISNULL(orderPrice),1,0),orderPrice DESC
		 
			LIMIT #offset#,#limit#