Files
oceanbase/tools/deploy/mysql_test/r/mysql/bench_count_distinct.result
2023-11-15 11:44:44 +00:00

7 lines
164 B
Plaintext

drop table if exists a1;
create table a1(rowkey_suffix int primary key, price int) ;
select count(distinct price) from a1;
count(distinct price)
100
drop table a1;