---
title: "关于insert的语句从查询获得数据，并且从序列获得ID，该如何写？"
author: "winzenghua"
date: "2008-12-25T23:01:00Z"
tags: []
slug: "insert-id"
draft: false
lastmod: "2008-12-25T23:01:00Z"
id: 987907
url: "https://java4gis.iteye.com/blog/987907"
---

![](http://imgcache.qq.com/ac/b.gif)

关于insert的语句从查询获得数据，并且从序列获得ID，该如何写？

![](http://imgcache.qq.com/ac/b.gif)INSERT INTO ZENGFK.MSG\_CONTENT  
(MSGCONTET\_ID, USER\_ID, CREATE\_DATE, MSG\_CONTENT)  
SELECT ZENGFK.CONTENTID\_B.NEXTVAL, A.*  
FROM (SELECT DISTINCT T.CLIENTID, T.LDATE, T.CONTENT  
FROM SMSGATE1.BAK\_SMS\_SENDINFO\_200807 T  
ORDER BY T.CLIENTID, T.LDATE) A;

引用楼主 ZengMuAnSha 的帖子:  
INSERT INTO ZENGFK.MSG\_CONTENT(msgcontet\_id,USER\_ID,CREATE\_DATE,MSG\_CONTENT)  
VALUES (ZENGFK.CONTENTID\_B.NEXTVAL,select distinct t.clientid,t.ldate,t.content  
from smsgate1.bak\_sms\_sendinfo\_200807 t order byt.clientid,t.ldate)