Sign in
apache
/
drill-test-framework
/
9a5d7ecf7f32f0e95c0ea874e75d785fdee9e51d
/
.
/
framework
/
resources
/
Functional
/
aggregates
/
aggregation
/
count_distinct
/
with_group_by_order_by_count_distinct_c_bigint.sql
blob: fbe71eb08d6da1dddf7bb42e072abec92bd2cbb5 [
file
] [
log
] [
blame
]
select
c_bigint
,
COUNT
(
DISTINCT
c_integer
)
from
alltypes
group
by
c_bigint
order
by
c_bigint
,
COUNT
(
DISTINCT
c_integer
)
desc
;