Consultas Utiles HQL

Seleccionar las ultimas 4 noticias
Query Name: getRecientNotices
Query: from Noticia n where n.id >= ( select (max(m.id)-4) from Noticia m) order by n.id desc