如图 查询每个工号最早收件运单号、最晚收件运单号、以及最早最晚相差的时间(秒) 首先查询每个工号最早收件运单号: select b1.e_code,b1.w_no as w2,b1.receive_tm from (select e_code,w_no,receive_tm,ROW_NUMBER() over(partition by e_code order by receive_tm )r2 from w_info