以用文件檔為來源:
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
arrow
arrow
    全站熱搜

    vbqa 發表在 痞客邦 留言(0) 人氣()