数据按照字段某个参数复制对应次数

将某份数据按照字段某个参数复制对应次数

方法一:

SELECT A,B,b.help_topic_id FROM (
SELECT A,B,C FROM dual)a
LEFT JOIN mysql.help_topic b ON b.help_topic_id < a.C

方法二:

select * from table
lateral view posexplode(split(space(C-1)," ")) tem as time,explode_date
posted @ 2022-07-31 17:01  KaneQi  阅读(4)  评论(0编辑  收藏  举报