http://blog.csdn.net/szchenrong/article/details/7441642
------解决方案--------------------
select *,in_date_time-lag(out_date_time)over(partition by operation_room_no order by in_date_time) from tb
详细解决方案
想求同类别的本条记录的in_date_time-上条记录的out_date_time解决思路
热度：25 发布时间：2016-04-24 07:30:48.0
http://blog.csdn.net/szchenrong/article/details/7441642
------解决方案--------------------
select *,in_date_time-lag(out_date_time)over(partition by operation_room_no order by in_date_time) from tb
相关解决方案