查新股网下配售

SELECT b.GPDM,a.IGSDM,ALTZZCBPSGS+BLTZZCBPSGS+CLTZZCBPSGS,FRPSGS,a.SSRQ from usrXGFXYSS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and ALTZZCBPSGS+BLTZZCBPSGS+CLTZZCBPSGS!=FRPSGS

SELECT b.GPDM,a.IGSDM,ALTZZYXSGZL+BLTZZYXSGZL+CLTZZYXSGZL,a.SSRQ from usrXGFXYSS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and ALTZZYXSGZL+BLTZZYXSGZL+CLTZZYXSGZL<>FRPSYXSGZL



新股表 中签率查错 有效申购/配号总数=1000or500
SELECT b.GPDM,a.IGSDM,SWFXYXSGZL/SWFXPHZS,a.SSRQ from usrXGFXYSS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and SWFXYXSGZL/SWFXPHZS is not null
and SWFXYXSGZL/SWFXPHZS not in(1000,500)
and a.SSRQ>'2015-1-1'


SELECT b.GPDM,a.IGSDM,SWFXGS/SWFXYXSGZL 计算得中签率,SWFXZQL 中签率,a.SWFXYXSGHS from usrXGFXYSS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and abs(SWFXGS/SWFXYXSGZL-SWFXZQL)>0.000000004
and a.SWFXYXSGHS is not null
and a.SSRQ>'2016-1-1'

SELECT b.GPDM,a.IGSDM,SWFXYXSGZL/SWFXGS 计算得倍数,SWFXCERGBS 倍数,a.SCXXFBRQ from usrXGFXYSS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and abs(SWFXYXSGZL/SWFXGS-SWFXCERGBS)>0.005
and a.SWFXYXSGHS is not null
and a.SCXXFBRQ>'2016-1-1'

SELECT b.GPDM,a.IGSDM,SWFXYXSGHS,a.SSRQ from usrXGFXYSS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and a.SSRQ>'2016-1-1'
order by a.SSRQ DESC



主要领导人介绍序号

SELECT b.GPDM 公司代码,a.XM 姓名,XH 序号, ZWMS 职位描述 from usrGSZYLDRJS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and a.XH<>1
and ZWMS='董事长、董事'
UNION ALL

SELECT b.GPDM 公司代码,a.XM 姓名,XH 序号, ZWMS 职位描述 from usrGSZYLDRJS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and a.XXFBRQ>'2010-01-01'
and a.XH<>4
and ZWMS='董事'
UNION ALL
SELECT b.GPDM 公司代码,a.XM 姓名,XH 序号, ZWMS 职位描述 from usrGSZYLDRJS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and a.XXFBRQ>'2010-01-01'
and a.XH<>3
and ZWMS='副董事长'
UNION ALL

SELECT b.GPDM 公司代码,a.XM 姓名,XH 序号, ZWMS 职位描述 from usrGSZYLDRJS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and a.XXFBRQ>'2010-01-01'
and a.XH<>5
and ZWMS='独立董事'
UNION ALL
SELECT b.GPDM 公司代码,a.XM 姓名,XH 序号, ZWMS 职位描述 from usrGSZYLDRJS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and a.XXFBRQ>'2010-01-01'
and a.XH<>6
and ZWMS='监事会主席'
UNION ALL

SELECT b.GPDM 公司代码,a.XM 姓名,XH 序号, ZWMS 职位描述 from usrGSZYLDRJS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and a.XXFBRQ>'2015-01-01'
and a.XH<>7
and ZWMS='职工监事'
UNION ALL


SELECT b.GPDM 公司代码,a.XM 姓名,XH 序号 , ZWMS 职位描述 from usrGSZYLDRJS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and a.XXFBRQ>'2015-01-01'
and a.XH<>10
and ZWMS='副总经理'
UNION ALL

SELECT b.GPDM 公司代码,a.XM 姓名,XH 序号  , ZWMS 职位描述 from usrGSZYLDRJS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and a.XXFBRQ>'2015-01-01'
and a.XH<>12
and ZWMS='董事会秘书' 
UNION ALL

SELECT b.GPDM 公司代码,a.XM 姓名,XH 序号  , ZWMS 职位描述 from usrGSZYLDRJS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and a.XXFBRQ>'2015-01-01'
and a.XH<>15
and ZWMS='财务总监' 
UNION ALL
SELECT b.GPDM 公司代码,a.XM 姓名,XH 序号  , ZWMS 职位描述 from usrGSZYLDRJS a,usrZQZB b
where b.IGSDM=a.IGSDM
and b.ZQSC IN (83,90)
and b.ZQLB in (1,2)
and a.XXFBRQ>'2015-01-01'
and a.XH<>22
and ZWMS='核心技术人员'