程序笔记的博客

with mon as( select mon::date mon from generate_series(date_trunc('year', now())::date, date_trunc('year', now())::date + '+1y -1d'::interval,'1mon'::interval) mon ) select * from...

select row_number() over(order by 业务号,主键,排序号) rn -- 行号 ,count(0) over() cnt -- 总条数 ,id from 表 order by 排序号,主键,业务号 offset (页号- 1)* 每页数量 limit 每页数量 ...

with d as ( select z.dictid ,z.dictlv ,z.dicttarget ,z.code ,z.code_p ,z.value ,z.enabled ,0 lv ,to_char(z.orderid,'fm000000') fullorder ...