Select Code to Download

            $c->model('Database1')->resultset('Table1')->search(
                undef,
...
                    order_by => ['group']
                },
            )

SELECT group FROM table1 me GROUP BY group ORDER BY group

   distinct => 1

            $c->model('Database1')->resultset('Table1')->search(
                undef,
...
                    order_by => ['group']
                },
            )

SELECT DISTINCT( group ) FROM table1 me ORDER BY group

   as => '...'