qq_33720460的博客

文章目录建表并插入数据获取下一行时间阶段累加添加序号建表并插入数据建表语句create table test1( id bigserial not null constraint test1_pk primary key, create_time timestamp default now());插入随机...

文章目录建表插入随机数统计连续出现次数建表create table signal( value smallint, record_datetime timestamp default now());插入随机数insert into signal(value)values (trunc(random() * (10 - 1)));ceil函数...