如图IDNO ACTION DATE TIME
001 IN 2007-01-01 9:00
001 OUT 2007-01-01 18:00
001 IN 2007-01-02 8:55
001 OUT 2007-01-02 17:55IDNO DATE IN OUT
001 2007-01-01 9:00 18:00
001 2007-01-02 8:55 17:55
再别的论坛竟然说无法实现...
我相信在这里一定有高手帮我解决这个问题
001 IN 2007-01-01 9:00
001 OUT 2007-01-01 18:00
001 IN 2007-01-02 8:55
001 OUT 2007-01-02 17:55IDNO DATE IN OUT
001 2007-01-01 9:00 18:00
001 2007-01-02 8:55 17:55
再别的论坛竟然说无法实现...
我相信在这里一定有高手帮我解决这个问题
一般用搜索case实现,也可以用游标:
select IDNO , DATE,IN =case ACTION when 'IN' then TIME end , OUT =case ACTION when 'OUT' then TIME end