HQL: The Hibernate Query Language
The Hibernate Query Language is executed using session.createQuery().
This tutorial includes from clause,Associations and joins, Aggregate functions,The order by clause,The group by clause,Subqueries.
The from clause
from Employee // Employee is class name mapped to EMPLOYEE TABLE
or
from Employee as e
or
from Employee e where e.empId = 3;
List empList = session.createQuery("from Employee").list();
Associations and joins
from Employee e where e.scopeModFlag = 1 and pc.isDeleted != 1
List empList = session.createQuery("from Employee e where e.scopeModFlag = 1 and pc.isDeleted != 1").list();
from Employee e order by e.name desc
List empList = session.createQuery("from Employee e order by e.name desc").list();
asc or desc indicate ascending or descending order respectively.
The group by clause
select e.dept, sum(e.salary), count(e) Employee e group by cat.dept
Subqueries
from Employee as e
where e.name = some (
select name.nickName from Name as name
)