Sign in
apache
/
drill-test-framework
/
9a5d7ecf7f32f0e95c0ea874e75d785fdee9e51d
/
.
/
framework
/
resources
/
Functional
/
aggregates
/
aggregation
/
count_distinct
/
with_min_max_c_float_group_by_6_cols.sql
blob: 071de20ba2e2586ae6adaf7845a6afa80c1532bb [
file
] [
log
] [
blame
]
select
count
(
distinct
c_float
),
max
(
c_float
),
min
(
c_float
)
from
alltypes_with_nulls
group
by
c_date
,
c_time
,
c_timestamp
,
c_boolean
,
c_varchar
,
c_integer
order
by
c_date
,
c_time
,
c_timestamp
,
c_boolean
,
c_varchar
,
c_integer
;