how to do group by in expression rule

Question

Hi All, 
 can we write this SQL query in a a!queryEntity() ( I mean the logic) 
 
 select * from TableName 
 where TableName.column1="order" 
 group by column2 
 
 I need to run this query in batches because i am having large data, i have written a stored procedure for this query but it dosen't worked

Peter Lewis · Answer

I'd suggest looking at this query recipe that describes how to group on fields in a!queryEntity().