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

##</code><code>##

SELECT group FROM table1 me GROUP BY group ORDER BY group

##</code><code>##

   distinct => 1

##</code><code>##

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

##</code><code>##

SELECT DISTINCT( group ) FROM table1 me ORDER BY group

##</code><code>##

   as => '...'