<statement id="queryTestList" resultMap="Test_Map">
    select * from(
    select t.*,rownum rn from(
  	select 
	 	col1,     
		to_char(A.TestTime,'YYYY-MM-DD HH24:MI:SS') as TestTime,       
  	from TestTable A where 1=1
  	<dynamic>
  		<isNotEmpty prepend="AND" property="col1">
  			lower(col1) like lower('%col1%')
  		</isNotEmpty>
  		<isNotEmpty prepend="AND" property="testtime1">
  			TESTTIME
between to_date(#testtime1#,'YYYY-MM-DD HH24:MI:SS')
  		</isNotEmpty>
  		<isNotEmpty prepend="AND" property="testtime2">
  			to_date(#testtime2#,'YYYY-MM-DD HH24:MI:SS') + 1 - 1/86400
  		</isNotEmpty>
  	</dynamic>
order by testtime desc nulls last
    ) t where rownum&lt;=#maxResult#
    ) where rn&gt;#firstResult#
  </statement>