select * from (select * from pick_task where deal_flag='0' order by create_time)WHERE rownum <= 2 order by rownum asc
次条语句是取出前两条记录!
select * from (select * from pick_task where deal_flag='0' order by create_time)WHERE rownum <= 2 order by rownum asc
次条语句是取出前两条记录!