qq_37141187的博客

数据库-----sql循环写入表数据。

sql用于判断的函数case when then else语法

数据库常用函数整理

分析函数之特殊函数（1）分析函数之偏移量函数lag(bgnpower,1,0) over(partition by unitid order by unitid,segno)lag(字段名，要向前偏移的行数，没有符合条件的默认值)lead(字段名，要向后偏移的行数，没有符合条件的默认值)①lag向前偏移②lead向后偏移（2）分析函数之ntile函数（好像是这样叫累计分布函数）具体看：oracle窗口函数--cume_dist() 、nth_value()、ntil.

select listagg(result1, '.') WITHIN GROUP (ORDER BY rownum) result1 from ( select lpad(result1,4,'0') result1 from( SELECT REGEXP_SUBSTR ('20.2.1.2','[^.]+',1,LEVEL) as result1 FROM DUAL CONNECT BY REGEXP_SUBSTR ('20.2.1.2','[^...

原始表：实现效果：实现方法：with aaa as( select '2021-01-01' as pdate,'90' as p1_value,'88' as p2_value,'82' as p3_value from dual union all select '2021-01-02' as pdate,'67' as p1,'92' as p2,'90' as p3 from dual)SELECT pdate, CASE WHEN LV...