一个sql

        String sql="select * from (select a.*,rank() over (order by order_id desc) pageorder from " +
                "(select o.order_id, o.applicant, to_char(o.date_called,'yyyy-mm-dd hh24:mi:ss') date_called," +
                "contact_phone,o.type, to_char(o.appointment_time,'yyyy-mm-dd hh24:mi') appointment_time," +
                "o.address,o.status,o.substatus,o.handle_region,o.process_instance_id," +
                "(select max(task_instance_id) from som_activities where order_id=o.order_id) task_instance_id from som_order o  " +
                " where "+where+"  order by o.order_id desc ) a ) " +
                " where pageorder between "+(new Integer(start).intValue() + 1)+" and "+new Integer(end);

 

 

 

String sql=
select * from
     (
         select a.*,rank() over (order by order_id desc) pageorder from
          (
               select o.order_id, o.applicant, to_char(o.date_called,'yyyy-mm-dd hh24:mi:ss') date_called  contact_phone,o.type, to_char(o.appointment_time,'yyyy-mm-dd hh24:mi') appointment_time
               o.address,o.status,o.substatus,o.handle_region,o.process_instance_id
               (
                    select max(task_instance_id) from som_activities where order_id=o.order_id
               )
               task_instance_id from som_order o  where "+where+"  order by o.order_id desc
           )
           a
    ) where pageorder between "+(new Integer(start).intValue() + 1)+" and "+new Integer(end);