Hello
I have a select that will give me the activity per worker per hour
SELECT
Worker,
Weight,
Date
FROM
PRODUCTION
ORDER BY Worker,Date
I need get the Production per worker per Day
SELECT
Worker,
SUM(Weight) AS TotWeight,
CAST(Date AS DATE) AS Date
FROM
PRODUCTION
ORDER BY Worker,Date
But I need to get the elapsed time per day for each worker
Can I do that in SQL with such Query ?
Thank for your help
GROUP BY DATE AND GET elapsed time
Posted - 05/29/2012 : 17:29:37
