row count with group by on multiple fields

[rohith reddy]

hi ,

I am trying to get total row count with a group by expression Using JPAquery in queryDSL. I am grouping on more than one column. 

consider sql example from w3 schools:  http://www.w3schools.com/sql/trysql.asp?filename=trysql_select_groupby_2

I need count of 26  grouped records in below example.

SELECT Shippers.ShipperName, Employees.LastName, COUNT(Orders.OrderID) AS NumberOfOrders

FROM ((Orders

INNER JOIN Shippers

ON Orders.ShipperID=Shippers.ShipperID)

INNER JOIN Employees

ON Orders.EmployeeID=Employees.EmployeeID)

Output of above query:

[rohith reddy]

 i did jpaQuery.list(Wildcard.count).size(); . before applying limit and offset, it worked. still wondering, if there is a better way to do this.

[timowest]

Instead if group by try a distinct count, that should be faster.