SELECT
    id as id,
    c03 as c03,
    c34 as c34
FROM
    (SELECT
        id,
        c03,
        c34
    FROM
        students
    where
        c34 in(
            ?, ?,?,?
        )
    order by
        id desc) o
group by
    c34;

private final void retrieveStudents(){
    final List result = currentSession()
            .createSQLQuery("SELECT id as id,c03 as c03,c34 as c34 FROM (SELECT id,c34,c03 FROM students where c34 in(:filters) order by id desc) o group by c34;")
            .setParameterList("filters",Arrays.asList(74,1812))
            .list();
    result.forEach(this::consumer1);
}

.addEntity(Student.class)

Column 'ACTIVE' not found.