想求同类别的本条记录的in_date_time-上条记录的out_date_timehttp://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
