<resultMaps>
    <resultMap id="SelectAllResultPerson" class="Person">
      <result property="Id" column="PER_ID" />
      <result property="FirstName" column="PER_FIRST_NAME" />
      <result property="LastName" column="PER_LAST_NAME" />
      <result property="BirthDate" column="PER_BIRTH_DATE" />
      <result property="WeightInKilograms" column="PER_WEIGHT_KG" />
      <result property="HeightInMeters" column="PER_HEIGHT_M" />
    </resultMap>
  </resultMaps>

  <parameterMaps>
    <parameterMap id="RoomStatusParameters" class="Hashtable">
      <parameter property="Start" column="" direction="Input" />
      <parameter property="End" column="" direction="Input" />
    </parameterMap>
  </parameterMaps>
  
  <statements>
    <select id="SelectPersonByPageNo" parameterMap="RoomStatusParameters"  resultMap="SelectAllResultPerson">
      SELECT
      PER_ID,
      PER_FIRST_NAME,
      PER_LAST_NAME,
      PER_BIRTH_DATE,
      PER_WEIGHT_KG,
      PER_HEIGHT_M
      FROM (select ROW_NUMBER() Over(order by PER_ID) as rowNum, *
      from PERSON) as t
      where rowNum between $Start$ and $End$
    </select>