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