hibernate - HQL Query using group by -


itemprop = "text">

I have the following square structure with the field FlareDo (map using Hibernate):

  • ID
  • Name

  • color

    How can I create an HQL query to get flowers?

I have tried this, but it does not work 

  from Faldao to F. where f.unitPrice and lt; = (Select from F2 to F2 as F2 (f2.unitprice) as F2, where f2.color = f.color) f.color
P

I suspect that the problem is comparing a single value in a set of results. With "in" & lt; If you try to change =, your query will be read: 

  In the form of Faladao where f.unitPrice (select F2.unitPrice) as an FDA in addition to FDA, I Finally, the 'group' has been removed because it will provide only one result for each color, and it has been mentioned in you. Question flower (s) you want to use by  
  instead of f.color  
 
?

Comments

Post a Comment