java db2 操作 建立临时表,插入数据

2024-12-25 21:48:29
推荐回答(1个)
回答1:

---以下是SQL:
CREATE GLOBAL TEMPORARY TABLE tem_expert as

select ROW_NUMBER() OVER() as SN,e.* from expert e where e.id in (list);

---其中list 是取出来的id