xbrl-报告期末按债券品种分类的债券投资组合信息

来源:互联网 发布:怎么看自己淘宝联盟pid 编辑:程序博客网 时间:2024/04/28 15:31

可转债取数(包含可交换债)

select sum(result) from (
select SUM(FZqsz) result FROM [PREFIX]A[DBCODE]JjHzGzb
WHERE FDate = to_date(‘[ENDDATE]’,’YYYY-MM-DD’) 
AND fkmbm in (select facctcode from [PREFIX]a[YYYY][DBCODE]laccount where facctcode like ‘1103__’ and facctattr like ‘%可转%’)
union
select SUM(FZqsz) result FROM [PREFIX]A[DBCODE]JjHzGzb
WHERE FDate = to_date(‘[ENDDATE]’,’YYYY-MM-DD’) 
AND fkmbm in (select facctcode from [PREFIX]a[YYYY][DBCODE]laccount where facctcode = ‘110315’)
)

0 0
原创粉丝点击