<div dir="ltr">Hi All,<div>I came across this link </div><div><br></div><div><a href="https://community.jboss.org/wiki/DroolsLanguageEnhancements#jive_content_id_SQL_Group_Operators">https://community.jboss.org/wiki/DroolsLanguageEnhancements#jive_content_id_SQL_Group_Operators</a></div>
<div><br></div><div><p style="margin:0px;padding:0px;border:0px;font-size:13px;font-family:'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif;vertical-align:baseline;color:rgb(61,61,61);line-height:19.5px">
select location, age, avg(income), min(income), max(income) from Person group by location, age //SQL</p><p style="margin:0px;padding:0px;border:0px;font-size:13px;font-family:'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif;vertical-align:baseline;color:rgb(61,61,61);line-height:19.5px;min-height:8pt;height:8pt">
</p><p style="margin:0px;padding:0px;border:0px;font-size:13px;font-family:'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif;vertical-align:baseline;color:rgb(61,61,61);line-height:19.5px">acc( $p : Person();<br>
[$l, $a] : distinct( $p.location, $p.age) )<br>acc( $p : Person( location == $l, age == $a );<br> $avgIncome : avg( $p.income ) ,<br> $minIncome : min( $p.income ),<br> $maxIncome : max( $p.income ) )</p>
<p style="margin:0px;padding:0px;border:0px;font-size:13px;font-family:'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif;vertical-align:baseline;color:rgb(61,61,61);line-height:19.5px;min-height:8pt;height:8pt">
</p><p style="margin:0px;padding:0px;border:0px;font-size:13px;font-family:'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif;vertical-align:baseline;color:rgb(61,61,61);line-height:19.5px">If we wanted to make a list of lists we could add:</p>
<p style="margin:0px;padding:0px;border:0px;font-size:13px;font-family:'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif;vertical-align:baseline;color:rgb(61,61,61);line-height:19.5px">acc( $l : List() from [$avgIncome, $minIncome, $maxIncome],</p>
<p style="margin:0px;padding:0px;border:0px;font-size:13px;font-family:'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif;vertical-align:baseline;color:rgb(61,61,61);line-height:19.5px"> list( $l )</p>
<p style="margin:0px;padding:0px;border:0px;font-size:13px;font-family:'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif;vertical-align:baseline;color:rgb(61,61,61);line-height:19.5px"><br></p><p style="margin:0px;padding:0px;border:0px;font-size:13px;font-family:'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif;vertical-align:baseline;color:rgb(61,61,61);line-height:19.5px">
Can some give me specific example with this</p><p style="margin:0px;padding:0px;border:0px;font-size:13px;font-family:'Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif;vertical-align:baseline;color:rgb(61,61,61);line-height:19.5px">
<br></p></div><div>Regards,<br clear="all"><div><br></div>-- <br><div dir="ltr">Raja Sekhar Amirapu<br>------------------------------------------------------<div>"If any anyone can do it, i can do it. If no one else can do it, i must do it"<br>
</div></div>
</div></div>