I have a SQL table as
empid to_day clock_in clock_out late_reason
001Acc 01/04/2016 9:12:08 18:33:57 Office work
001Acc 02/04/2016 10:12:08 19:33:57 Home work
001Acc 03/04/2016 11:12:08 20:33:57 Sick
001Acc 04/04/2016 10:12:08 19:53:57 Car disorder
001Acc 05/04/2016 13:12:08 19:33:57 Hospital
After ran following query:
SELECT
to_day,
(
TIME_TO_SEC(clock_out) - TIME_TO_SEC(clock_in)
) AS worktime,
late_reason
FROM
myTable
WHERE
emp_id = '001Acc'
AND (
to_day BETWEEN "2016-04-01"
AND "2016-04-05"
)
I can get
to_day worktime late_reason
01/04/2016 33709 Office work
02/04/2016 33709 Home work
03/04/2016 33709 Sick
04/04/2016 34909 Car disorder
05/04/2016 22909 Hospital
***Total 158945***
(without the TOTAL row). But I want to add a row for total of worktime column from the query (in red in the image). Is it possible?
Please help me to rewrite the query.
Thanks.