自用数据库查询语句

来源：互联网发布：软件开发需求说明书编辑：程序博客网时间：2024/05/21 17:15

SELECT l.Bond_ID, b.FRN_Index_ID, b.Fixing_MA_Days, b.Fixing_Preceds, b.First_Index_Rate,

b.Short_Name, b.Full_Name, b.Issuer_Code, b.Interest_Start_Date, b.Maturity_Date,
b.Maturity_Term_Y, b.Maturity_Term, b.Term_Unit, b.Coupon_Rate_Spread, b.Coupon_Rate_Current, b.Coupon_Frequency,
b.Compound_Frequency, b.Redemption_No, b.Redemption_Str, b.Compensate_From, b.Compensate_Rate
FROM sdata.sdata_bond_base b, sdata.sdata_bond_list l

WHERE b.Bond_Key = l.Bond_Key
and l.Bond_ID like '125214%'

and b.Coupon_Type = 'DSC'

and b.Maturity_Date >= '20150617'

ORDER BY Redemption_Str DESC

SELECT l.Bond_ID, b.Bond_ID, b.Coupon_Type, b.FRN_Index_ID, b.Fixing_MA_Days, b.Fixing_Preceds, b.First_Index_Rate, b.Option_Type,
b.Short_Name, b.Issuer_Code, b.Interest_Start_Date, b.Maturity_Date, b.Bond_Subtype,
b.Maturity_Term_Y, b.Maturity_Term, b.Term_Unit, b.Coupon_Rate_Spread, b.Coupon_Rate_Current, b.Coupon_Frequency,
b.Compound_Frequency, b.Redemption_No, b.Redemption_Str, b.Compensate_From, b.Compensate_Rate,
b.Fixing_Digit, b.Fixing_Tailing, b.Cap, b.Flr

FROM sdata.sdata_bond_base b, sdata.sdata_bond_list l

WHERE
b.Bond_Key = l.Bond_Key AND
b.Coupon_Type = 'FRB' AND
b.Bond_Type != 'ABS' AND
b.Maturity_Date > '20150601' AND
(b.Maturity_Term_Y * 100)%100 != 0

ORDER BY b.Fixing_Digit ASC

0 0