SQLQuery query = session.createSQLQuery(sql.toString());
query.setFirstResult((offset - 1) * length);
query.setMaxResults(length);
list = query.list();
query.setFirstResult((offset - 1) * length);
query.setMaxResults(length);
list = query.list();