SELECT (InvoiceTotal - PaymentTotal - CreditTotal) AS BalanceDue
FROM Invoices
WHERE BalanceDue > 0 --error
SELECT (InvoiceTotal - PaymentTotal - CreditTot
阅读背景：
在WHERE子句中引用别名(在SELECT中计算)
来源：互联网
分享到：
