HQL order by.

Order by clause is one way to group a series of object in sorted form. There is two pattern of sorting either in ascending(asc) or descending(desc).If you don?t mention, order by automatically sorted the list in ascending order. Here is an example of order by clause. Since we didn?t mention ?asce? or ?desc? it will return employee name into ascending order.

If you want to print employee name into descending order you can follow the following HQL ?

String hql="Select emp FROM Employee emp ORDER BY name desc";

Example :

package net.roseindia.main;
import java.util.Iterator;
import net.roseindia.table.Employee;
import net.roseindia.util.HibernateUtil;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;

public class HQLOrderBy{
    public static void main(String []args){
        SessionFactory sessionFactory =HibernateUtil.getSessionFactory();
        Session session=sessionFactory.openSession();
        String hql="Select emp FROM Employee emp ORDER BY name";
        Query query=session.createQuery(hql);
        Iterator it=query.iterate();
        while(it.hasNext()){
            Employee employee=(Employee)it.next();
            System.out.println(employee.getName());
        }

        session.close();
    }
}

Output :

Hibernate: select employee0_.emp_id as col_0_0_ from employee employee0_ order by employee0_.name
Mandy
Ron
Roxi
Som