用select wpt.work_plan_id,wpt.begin_time,wpt.bus_id,wpt.status,RowNum from WORK_PLAN_TABLE wpt
where RowNum = 1 and wpt.work_plan_id = 1查询和用用select wpt.work_plan_id,wpt.begin_time,wpt.bus_id,wpt.status,RowNum from WORK_PLAN_TABLE wpt
where RowNum = wpt.work_plan_id 查到的结果完全不同,用前者能查到一条记录,用后者查不到任何记录,但两者说的不是同一个意思吗,而且即使有差别也应该是后者可能查到的记录更多吧,为什么这样呢,真不理解,望高人指点
一只萌萌小番薯