GROUP BY more than one column

[twocolors]

#!/usr/bin/env perl

use strict;
use warnings;

use feature ':5.10';

use SQL::Composer;

my $expr = SQL::Composer::Select->new(
    from     => 'table',
    columns  => ['a', 'b'],
    group_by => ['foo', \'CEILING(num)']
);

say $expr->to_sql;

when use

Not a SCALAR reference at /Users/free/.perl5/lib/perl5/SQL/Composer/Select.pm line 67.

[vti]

Try it!

[twocolors]

thx