原创

oracle-通过条件查询生成表数据库

create table newlogname_same as (Select * From 用户_整合  L  Where L.Newlogname In (
Select L.Newlogname
  From 用户_整合 L Where Exists (Select * From Loginid_Qy Q Where Q.用户id = L.用户id)
                         Group By L.Newlogname
                        Having Count(1) > 1))

正文到此结束
本文目录