title: how to express the following SQL in HQL
body: <p>How to express the following SQL in HQL. </p>
  
  <pre><code>select *  from (
              select *
              from vw_report_alert r 
              where r.user_id=147  
              order by r.event_creation_date DESC
             ) 
       where rownum &lt;= 25
       order by alert_id DESC
  </code></pre>
  
  <p>Thanks</p>