当前位置：网站首页>lpad()函数和(row_number()over( order by )+ ...)

lpad()函数和(row_number()over( order by )+ ...)

2022-07-19 16:39:00 【扬州的你】

--LPAD自动在前面加数值，例子里面是0，凑足14位
select
'ZCZQ45' || LPAD((row_number() over(order by t1.C_PORT_CODE)+tmp_tbl.max_num), 14, '0') as abc
from  bbb

版权声明
本文为[扬州的你]所创，转载请带上原文链接，感谢
https://blog.csdn.net/jtpython666/article/details/121867002