求一sql

时间排列,表格式如下

emp_id card_id sing_time
06F00734 00734 2007-03-23 10:21:43
06F00734 00734 2007-03-23 10:23:00
06F00734 00734 2007-03-23 10:24:49
06F00747 00747 2007-03-23 12:34:52
01F00020 00020 2007-03-23 12:35:52
04F00413 00413 2007-03-23 12:36:25
03M00262* 00262* 2007-03-23 12:36:27
02M00093* 00093* 2007-03-23 12:36:27
02F00137 00137 2007-03-23 12:36:29
02F00128 00128 2007-03-23 12:36:30
02F00127 00127 2007-03-23 12:36:31
02F00114 00114 2007-03-23 12:36:32

用条sql得到如下格式
emp_id card_id t_day date1(第一次时间) date2(最后一次时间)
06F00734 00734 2007-03-23 10:21:43 10:24:49

先感谢各位高手帮忙

SQL code

select emp_id,card_id,min(sing_time),max(sing_time) from ? group by emp_id,card_id

试试看行不行，这个东西应该发到SQL版去问