SQL查询在妇产科医院统计工作中的应用  

Application of SQL query in statistical work in an obstetrics and gynecology hospital

作　　者：周哲颖 史佳敏 黄锐 Zhou Zheying;Shi Jiamin;Huang Rui(Shanghai First Maternity and Infant Hospital Tongji University School of Medicine, Shanghai 200125, China)

机构地区：[1]同济大学附属第一妇婴保健院,上海200125

出　　处：《中国医院统计》2021年第6期546-550,共5页Chinese Journal of Hospital Statistics

摘　　要：大数据背景下的医院统计工作中,结构化查询语言(SQL)查询能快速实现数据的深层检索。研究通过横向关联、纵向提取、不同时间、不同对象间4个角度的实例分析,展示应用SQL技术协助统计人员完成当下统计工作的新挑战,为医院统计方法应用提供参考。Statistics data can be deep retrieved through SQL query in hospital statistics in the era of big data.This paper shows the application of SQL in the new challenge of hospital statistics by analyzing four examples of horizontal correlation,vertical extractions,different time correlation,and different subject correlation,to provide references for the application of hospital statistical methods.

关 键 词：医院统计 SQL查询 深层检索 

分 类 号：R195.1[医药卫生—卫生统计学]