以用文件檔為來源:
0101 A 2001/10/01 07:51:45
0101 A 2001/10/01 08:54:48
0101 A 2001/10/01 09:51:25
0101 A 2001/10/01 12:01:10
0101 A 2001/10/01 12:59:05
0101 A 2001/10/01 13:06:08
0101 A 2001/10/01 15:02:01
0101 A 2001/10/01 17:04:06
0101 A 2001/10/02 08:15:38
0101 A 2001/10/02 12:05:09
0101 A 2001/10/02 12:57:02
0101 A 2001/10/02 17:01:08
我的SQL:
SELECT BeginDate, UserNo, UserName, MIN(BeginTime) AS Workstart, MAX(BeginTime)
AS Workend
FROM `User`
GROUP BY BeginDate, UserNo, UserName
ORDER BY BeginDate
0101 A 2001/10/01 07:51:45
0101 A 2001/10/01 08:54:48
0101 A 2001/10/01 09:51:25
0101 A 2001/10/01 12:01:10
0101 A 2001/10/01 12:59:05
0101 A 2001/10/01 13:06:08
0101 A 2001/10/01 15:02:01
0101 A 2001/10/01 17:04:06
0101 A 2001/10/02 08:15:38
0101 A 2001/10/02 12:05:09
0101 A 2001/10/02 12:57:02
0101 A 2001/10/02 17:01:08
我的SQL:
SELECT BeginDate, UserNo, UserName, MIN(BeginTime) AS Workstart, MAX(BeginTime)
AS Workend
FROM `User`
GROUP BY BeginDate, UserNo, UserName
ORDER BY BeginDate
全站熱搜
留言列表