INSERT INTO dbo.TwitterHot
( UName ,
UID ,
CataID ,
addDate ,
IsValid ,
SM ,
Sort ,
PID
)
SELECT UName,UID,CataID,AddDate,1,0,0,PID FROM dbo.TwitterPerson WHERE
PID IN (SELECT MIN(PID) FROM TwitterPerson WHERE
UName IN ('苏渝','封起De日子','冯矿伟','沙黾农','图锐','凯恩斯','梁永祥','李亚东','新9059a','何群荣','侯宁','股市风云','一和家家','曹攀','李飞','狼啸极行','乐嘉庆','冰冷','黄一苇','蒋有衡','淘金客','陈晓慧','吴徐张','李海','spengq','占豪','廖料','周海涛','谢卫','俞涌','李春瑜','朱军','李薇','美股','黄永耀','王雅媛','黄鑫','董广阳','闫淦智','胡立峰')
GROUP BY UID)
获取的多条数据方法 并且导入到新数据表中
最新推荐文章于 2018-05-31 12:03:20 发布