Hello ,
i am struggling to identify how to add a summary row to a query I am implementing. I have 2 columns, Name, time worked, I want to identify two things; 1. the total time worked per name, and 2 the total time worked by everyone. Can you help ?
Current Query:
SELECT Name, sum(hours) AS Hours
FROM timecard
Group by Name;
Goal shown below.
Name Hours
John 5
Mary 6
Ed 7
Total 18<----THIS IS THE ROW I NEED TO ADD!!!