SELECT CASE WHEN GROUPING(AccountDescription) = 1
THEN '*ALL*' ELSE AccountDescription END AS Account,
CASE WHEN GROUPING(VendorState) = 1
THEN '*ALL*' ELSE VendorState END AS State,
SUM(InvoiceLineItemAmount) AS LineItemSum FROM AP.dbo.GLAccounts
JOIN AP.dbo.InvoiceLineItems ON GLAccounts.AccountNo = InvoiceLineItems.AccountNo
JOIN AP.dbo.Invoices ON InvoiceLineItems.InvoiceID = Invoices.InvoiceID
JOIN AP.dbo.Vendors ON Invoices.VendorID = Vendors.VendorID
GROUP BY AccountDescription, VendorState WITH CUBE
Yes it would be
The top answer is correct
Answer:
Pneumatics use easily-compressible gas like air or pure gas. Meanwhile, hydraulics utilize relatively-incompressible liquid media like mineral oil, ethylene glycol, water, synthetic types, or high temperature fire-resistant fluids to make power transmission possible
Explanation: