Adding a Summary in SQL Posted August 20, 2019 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!!!
Adding a Summary
in SQL
Posted
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!!!