<sql id="paginationStart">
        <dynamic>
            <isNotEqual property="pagination" compareValue="false">
            <![CDATA[ select * from (select row_.*,rownum rownum_ from ( ]]>
            </isNotEqual>
        </dynamic>
    </sql>
 
    <sql id="paginationEnd">
        <dynamic>
            <isNotEqual property="pagination" compareValue="false">
            <![CDATA[ ) row_ where rownum <= #end#) where rownum_ > #start# ]]>
            </isNotEqual>
        </dynamic>
    </sql>
 
    <sql id="orderBy">
        <isNotEmpty property="sort">
        <![CDATA[ ORDER BY $sort$ $dir$ ]]>
        </isNotEmpty>
    </sql>