On 12/02/2014, Raja Sekhar <[email protected]> wrote:
> Hi All,
> I came across this link
>
> https://community.jboss.org/wiki/DroolsLanguageEnhancements#jive_content_id_SQL_Group_Operators

Skip down to the red "Done" and disregard everything before unless
you'd like to implement one of those proposals :-)

-W

>
> select  location, age, avg(income), min(income), max(income) from Person
> group by location, age  //SQL
>
>
>
> acc( $p : Person();
>         [$l, $a] : distinct( $p.location, $p.age) )
> acc( $p : Person( location == $l, age == $a );
>        $avgIncome : avg( $p.income ) ,
>        $minIncome : min( $p.income ),
>        $maxIncome : max( $p.income ) )
>
>
>
> If we wanted to make a  list of lists we could add:
>
> acc( $l : List() from [$avgIncome, $minIncome, $maxIncome],
>
>        list( $l )
>
>
> Can some give me specific example with this
>
>
> Regards,
>
> --
> Raja Sekhar Amirapu
> ------------------------------------------------------
> "If any anyone can do it, i can do it. If no one else can do it, i must do
> it"
>
_______________________________________________
rules-users mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/rules-users

Reply via email to