Sign in
apache
/
drill-test-framework
/
0c85b4fdd97d4bceb9f295eb434983b210bff100
/
.
/
framework
/
resources
/
Functional
/
aggregates
/
aggregate
/
aggregate4.q
blob: 992ef93ebcbb44d0d5f6b94aef7c729bad239f08 [
file
]
select
cast
(
c_groupby
as
varchar
(
5
)),
sum
(
c_int
),
sum
(
c_bigint
),
sum
(
c_float4
),
sum
(
c_float8
)
from
data
where
c_row
<>
5
and
c_row
<>
6
and
c_row
<>
7
and
c_row
<>
9
and
c_row
<>
10
group
by
c_groupby
;