{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["SQL Results","SQL Statement"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"SQL Results","index":0,"n_rows":63,"n_cols":8,"rows_kept":63,"flags":["formulas_cached_only"]}
["序号","学号","姓名","性别","一级学科","专业名称","学院","学生类别"]
[1,"081222019","李丽华","女","","","MBA学院","专业学位(非学历)"]
[2,"20092711004","邓嘉雯","女","","","MBA学院","专业学位(非学历)"]
[3,"20102711012","杜戈","男","","","MBA学院","专业学位(非学历)"]
[4,"20102711017","黄碧茹","女","","","MBA学院","专业学位(非学历)"]
[5,"20102711022","黄蕊","女","","","MBA学院","专业学位(非学历)"]
[6,"20102711025","劳瑜婷","女","","","MBA学院","专业学位(非学历)"]
[7,"20102711026","李华真","男","","","MBA学院","专业学位(非学历)"]
[8,"20102711029","梁景斌","男","","","MBA学院","专业学位(非学历)"]
[9,"081212002","曹继成","男","","","MBA学院","专业学位"]
[10,"081212063","徐昌伟","男","","","MBA学院","专业学位"]
[11,"20092710069","盛菲","女","","","MBA学院","专业学位"]
[12,"20092710075","谭佩欣","女","","","MBA学院","专业学位"]
[13,"20092710087","温志量","男","","","MBA学院","专业学位"]
[14,"20092710095","谢璇","女","","","MBA学院","专业学位"]
[15,"20092710104","张秉怡","男","","","MBA学院","专业学位"]
[16,"20102710015","陈茂婵","女","","","MBA学院","专业学位"]
[17,"20102710017","陈文","男","","","MBA学院","专业学位"]
[18,"20102710029","龚俊杰","男","","","MBA学院","专业学位"]
[19,"20102710030","关小莉","女","","","MBA学院","专业学位"]
[20,"20102710067","刘连军","男","","","MBA学院","专业学位"]
[21,"20102710079","罗颖","女","","","MBA学院","专业学位"]
[22,"20102710108","魏荣环","男","","","MBA学院","专业学位"]
[23,"20102710111","武剑宇","男","","","MBA学院","专业学位"]
[24,"20102710136","张娜","女","","","MBA学院","专业学位"]
[25,"20102810014","史智慧","女","翻译","翻译","MTI中心","专业学位"]
[26,"20102810104","丁欣如","女","翻译","翻译","MTI中心","专业学位"]
[27,"20102810113","王中妍","女","翻译","翻译","MTI中心","专业学位"]
[28,"20071293001","刘鑫磊","男","","外国语言学及应用语言学","MTI中心","同等学力"]
[29,"20081293001","柯蔚蔓","女","","外国语言学及应用语言学","MTI中心","同等学力"]
[30,"20081293002","钟蔚文","女","","外国语言学及应用语言学","MTI中心","同等学力"]
[31,"20091210006","陈满键","女","外国语言文学","外国语言文学 翻译学","高翻学院","硕士研究生"]
[32,"20091210022","刘晓佳","女","外国语言文学","外国语言文学 翻译学","高翻学院","硕士研究生"]
[33,"20091210027","舒亚莲","女","外国语言文学","外国语言文学 翻译学","高翻学院","硕士研究生"]
[34,"20091210040","文燕","女","外国语言文学","外国语言文学 翻译学","高翻学院","硕士研究生"]
[35,"20091210060","左静林","男","外国语言文学","外国语言文学 翻译学","高翻学院","硕士研究生"]
[36,"07001001","曹山鹰","男","外国语言文学","英语语言文学","高翻学院","博士研究生"]
[37,"07001011","杨贵章","男","外国语言文学","英语语言文学","高翻学院","博士研究生"]
[38,"20091220002","黄晓佳","男","外国语言文学","外国语言文学 翻译学","高翻学院","博士研究生"]
[39,"20091220006","马海燕","女","外国语言文学","外国语言文学 翻译学","高翻学院","博士研究生"]
[40,"20070111118","胡波","女","","外国语言学及应用语言学","英文学院","同等学力"]
[41,"20070111119","王茹","女","","外国语言学及应用语言学","英文学院","同等学力"]
[42,"20090110020","王皓","女","外国语言文学","英语语言文学","英文学院","硕士研究生"]
[43,"20090110036","郑吟","女","外国语言文学","英语语言文学","英文学院","硕士研究生"]
[44,"20090110136","赵倩","女","外国语言文学","外国语言学及应用语言学","英文学院","硕士研究生"]
[45,"081401109","赵红石","女","","英语语言文学","英文学院","高校教师"]
[46,"20080111115","姜天伟","男","","英语语言文学","英文学院","高校教师"]
[47,"20080111116","陈秋骆","女","","外国语言学及应用语言学","英文学院","高校教师"]
[48,"20080111117","李婷","女","","外国语言学及应用语言学","英文学院","高校教师"]
[49,"20090111005","林运珍","女","","英语语言文学","英文学院","高校教师"]
[50,"20100710211","焦杨","女","","","中文学院","专业学位"]
[51,"20100710223","覃思","女","","","中文学院","专业学位"]
[52,"20090710101","池榕","女","中国语言文学","比较文学与世界文学","中文学院","硕士研究生"]
[53,"20100710110","张瑶","女","中国语言文学","比较文学与世界文学","中文学院","硕士研究生"]
[53,"05001016","张革承","女",null,"外国语言学及应用语言学","文科基地","博士研究生"]
[53,"06001004","黄永平","男",null,"外国语言学及应用语言学","文科基地","博士研究生"]
[53,"07000003","高维","女",null,"外国语言学及应用语言学","文科基地","博士研究生"]
[53,"080013003","何嫣","女",null,"外国语言学及应用语言学","文科基地","博士研究生"]
[53,"080013004","刘平","女",null,"外国语言学及应用语言学","文科基地","博士研究生"]
[53,"080013009","徐睿","女",null,"外国语言学及应用语言学","文科基地","博士研究生"]
[53,"20092520001","蔡激浪","男",null,"外国语言学及应用语言学","文科基地","博士研究生"]
[53,"20092520008","马军军","男",null,"外国语言学及应用语言学","文科基地","博士研究生"]
[53,"20092520009","田启林","男",null,"外国语言学及应用语言学","文科基地","博士研究生"]

{"sheet":"SQL Statement","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"flags":["formulas_cached_only"]}
["select xwzxx.xh 学号,xwzxx.xm 姓名,xwzxx.xb 性别,xwzxx.csy 出生年,xwzxx.csm 出生月,xwzxx.csd 出生日,\nxwzxx.xxmc 学校名称,txxx.zymc 一级学科,vxy.zymc 专业名称,tbx.xkmc 学科名,xwzxx.xwzh 学位证号,txd.yxmc 学院,txx.xslbmc 学生类别\nfrom\n(select  a.xh ,b.xm ,decode(b.xbdm,'1','男','女') as xb,\nto_char(b.csrq,'yyyy') csy,to_char(b.csrq,'mm') csm,to_char(b.csrq,'dd') csd,\n'广东外语外贸大学' xxmc,\nsubstr(b.zydm,1,4) yjxkm,b.zydm,a.xwzh,xslbdm,yxdm\n--(select c.zymc from V_XB_YJSZY c where c.zydm=b.zydm) 专业,\n--(SELECT d.zymc FROM T_XKJS_XKXXGL_XKZYML d WHERE d.zydm=a.xkmlm) 学科\nfrom T_BYXW_ZSGL_XWZXX a,t_xjgl_xjxx_yjsjbxx b where a.xh=b.xh and a.pcdm='2012-2013-1' and b.xslbdm='01' order by a.xh)xwzxx\nleft join v_xb_yjszy vxy on xwzxx.zydm=vxy.zydm\nleft join t_bzgb_xk tbx on substr(xwzxx.zydm,1,2)=tbx.xkdm\nleft join t_xb_dw txd on xwzxx.yxdm=txd.yxdm\nleft join t_xb_xslb txx on xwzxx.xslbdm=txx.xslbdm\nleft join T_XKJS_XKXXGL_XKZYML txxx on xwzxx.yjxkm=txxx.zydm\n--where --xwzxx.xh in(select xh from V_BYXW_XWTL_FWHLLMD where XSLBDM in( '11','18') and  ZT='9'  and  FWHJYSYXW = '1' and  PCDM = '5' )\norder by xwzxx.xwzh"]