＋设为首页 ＋添加到收藏夹
有一个关于考勤方面的表，数据如下所示：
date time
2002-05-08 08:18:04
2002-05-08 12:10:15
2002-05-08 12:28:42
2002-05-08 18:53:30
2002-05-09 08:18:39
2002-05-09 12:07:13
2002-05-09 12:31:05
2002-05-09 19:00:57
2002-05-09 19:01:37
. .
. .
. .
现在我需要将每一天最早的时间和最晚的时间放到另外一张表里面，对于上面的例子应该是这样子的：
date time1 time2
2002-05-08 08:18:04 18:53:30
2002-05-09 08:18:39 19:01:37
. . .
. . .
. . .
请各位给出详细的sql语句，Thanks！
select max(timel) as time1,min(time2) as time2 from 考勤表 group by date
或
select dist..(唯一记录,忘记全称请查一下）date, max(timel) as time1,min(time2) as time2 from 考勤表 group by date
select max(timel) as time1,min(time2) as time2 from 考勤表 group by date
或
select dist..(唯一记录,忘记全称请查一下）date, max(timel) as time1,min(time2) as time2 from 考勤表 group by date
