oracle 嵌套查询

select dat.id,dat.voucher_id,dat.type,dat.state,dat.start_point,dat.start_floor,dat.end_point,dat.end_floor,dat.box_no,dat.node_str,dat.task_type from dis_agv_task datinner join (select dar.task_id,dar.car_id              from (select dar.task_id,dar.car_id                      from dis_agv_route dar                     where dar.car_id = #{carId}                     order by dar.created_time desc) dar             where rownum = 1) dar   on dat.id = dar.task_idwhere dat.state = #{state}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!