MYSQL方法:SELECT (@i :=@i + 1) as ‘index’
clickhouse方法:rowNumberInAllBlocks()+1
select rowNumberInAllBlocks()+1, district_id from bir_birth_certificate_record_info
2023-07-23 22:49:10
MYSQL方法:SELECT (@i :=@i + 1) as ‘index’
clickhouse方法:rowNumberInAllBlocks()+1
select rowNumberInAllBlocks()+1, district_id from bir_birth_certificate_record_info