如何在SQL中的查询中创建一列的SUM？

Question

I have one table with multiple columns. I am needing to create an SQL query to display certain columns based off of the user input from a datepicker and a select box. I have done that just fine. However, I am needing one of the result columns to be totaled at the bottom of the display table. I cannot figure out how to create a result within my current query to display the totaled column. Essentially, I would like the WTTotal column to be totaled into a separate cell. My current query is below. I really think this is something simple that I just can't seem to see.

SELECT REPLACE(Client,',',' ') AS Client,WorkTicketNum,Lease,Date,OrderedBy,WTTotal 
FROM WorkTicket 
WHERE Date BETWEEN '2014-10-01' AND '2014-10-31' AND Invoiced IS NULL 
ORDER BY Client 

Answer 1

SELECT REPLACE(Client,',',' ') AS Client,WorkTicketNum,Lease,Date,OrderedBy,WTTotal 
FROM WorkTicket 
WHERE Date BETWEEN '2014-10-01' AND '2014-10-31' AND Invoiced IS NULL 
ORDER BY Client 
UNION ALL
SELECT 'Total', NULL, NULL, NULL, NULL, SUM(WTTotal)
FROM WorkTicket
WHERE Date BETWEEN '2014-10-01' AND '2014-10-31' AND Invoiced IS NULL;