Hi,
I need to calculate the query recordCount of the following query:

SELECT FIELD, FIELD1 , count(FIELD2)
FROM TABLE
WHERE FIELD IS NOT NULL
GROUP BY FIELD, FIELD1
ORDER BY FIELD, FIELD1

How can I do this using HQL ?

suppose you have mapped your Table1 with Employee Class.
private String deptName;
private String managerName;
private String empName;

now your HQL query will be as follows.

select e.deptName, e.managerName, count(e.empName)
from Employee e
where e.deptName is not null
group by e.deptName, e.managerName
order by e.deptName, e.managerName

hope it helps

Abid