1 List students =session.createQuery("select c.name, count(s) from Student s join s.classes c " +
2 "group by c.name order by c.name").list();
3 for (Iterator iter=students.iterator(); iter.hasNext();) {
4 Object[] obj = (Object[])iter.next();
5 System.out.println(obj[0] + ", " + obj[1]);
6 }
2 "group by c.name order by c.name").list();
3 for (Iterator iter=students.iterator(); iter.hasNext();) {
4 Object[] obj = (Object[])iter.next();
5 System.out.println(obj[0] + ", " + obj[1]);
6 }