<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
   "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="net.myorg.persistence.pojo">
   <class name="Document" table="Document" mutable="false" lazy="true">
      <cache usage="read-only" />
      <id name="unid" type="string" length="32" column="dcm_unid">
         <generator class="assigned" />
      </id>
      <property name="identifier" column="dcm_identifier"/>
      <!-- other attributes -->       

   
      <joined-subclass name="News" table="News" lazy="true">
         <key column="dcm_unid" />
         <property name="fio" column="nws_fio"/>
         <!-- other attributes -->
      </joined-subclass>
   </class>
</hibernate-mapping>

   Criteria query = session.createCriteria(News.class).setMaxResults(2);
   List news = query.list();

select * from (
   select rownumber() over() as rownumber_, // and other attributes
      from LIGAOL.News_big this_ inner join LIGAOL.Document_big this_1_ on this_.dcm_unid=this_1_.dcm_unid
   ) as temp_
   where rownumber_ <= 2

select rn, Document.*, News.*from (
   select * from
      (select dcm_unid , rownumber() over(order by d.dcm_viewFrom desc) as rn               
         from Document d) as t1       
      where rn <= 2) as t2     
   join News on News.dcm_unid = t2.dcm_unid join Document on Document.dcm_unid = t2.dcm_unid;