This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Thanks for the reply but what I need is to build such HQL using criteria, the HQL example works fine. I just want to create it using Criteria interface because I need to use this as a subquery for another Criteria.