开启多行查询模式:
clickhouse-client -m
更改表名:
rename table t1 to t2
修改列信息:
alter table scott.emp modify column hiredate datetime;
limit by 语句:
limit 10 by class :相当于分组排序,对于class分组,然后取10个。