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

doi:10.3969/j.issn.1006-5253.2021.06.014

Abstract
Figure/Table
References (0)
Related Citation (11)

Download: PDF (936 KB) HTML (1 KB)
Export: BibTeX | EndNote (RIS)

Abstract 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.

Key words： hospital statistics SQL query deep retrieval

Received: 10 August 2021

	Service

	E-mail this article
	Add to my bookshelf
	Add to citation manager
	E-mail Alert
	RSS
	Articles by authors
	Zhou Zheying
	Shi Jiamin
	Huang Rui

Cite this article:

Zhou Zheying,Shi Jiamin,Huang Rui. Application of SQL query in statistical work in an obstetrics and gynecology hospital[J]. journal1, 2021, 28(6): 546-550.

URL:

http://manu58.magtech.com.cn/Jwk_zgyytj/EN/10.3969/j.issn.1006-5253.2021.06.014 OR http://manu58.magtech.com.cn/Jwk_zgyytj/EN/Y2021/V28/I6/546

［1］史文宗，刘瑞吉，杨奕．医改新形势下医院统计工作管理模式的探讨［J］．中国医院统计，2020，27(2)：153-156．
［2］马赫，葛丽，刘颖．复杂检索需求下SQL在医院统计中的应用思路［J］．中国卫生统计，2020，37(1)：136-140．
［3］陈美玲，温星来，孙小会，等．基于SQL的非计划再入院患者查询统计［J］．中国病案，2020，21(5)：36-38．
［4］郑阿奇．SQL Server实用教程［M］．3版．北京：电子工业出版社，2009．
［5］黄守忠．浅析数据库中的数据提取方法和sql语句优化［J］．科技展望，2016，26(24)：14．
［6］杨业春. 基于SQL的医院病种和手术统计监测应用实例分析［J］．中国医院统计，2019，26(2)：111-114． 

[1]	Li Xinhao，Zhou Huoming，Lai Fuhu，Xu Jun，Deng Juanjuan， Luo Yan. Application of VBA in the field of hospital statistics[J]. journal1, 2021, 28(4): 372-379.
[2]	Han Dong, Ye Yunshao . R markdown and its application in repetitive hospital statistical analysis report[J]. journal1, 2020, 27(6): 554-557.
[3]	Jiang Suling,Sun Boxing,Deng Zhiyu,Li Dan.. Investigation on the current situation of hospital statistics in Sichuan Province under the background of big data[J]. journal1, 2020, 27(5): 455-459.
[4]	Yang Yechun, He Jiajia, Hu Wei. . Current situation and countermeasures of hospital statistics in internet era[J]. journal1, 2020, 27(5): 439-441.
[5]	Lai Fuhu, Zhang Zheng, Xu Qingshi, Zhuang Jiachuan, Chen Junying, Zhou Huoming, Ye Xizhan. . Application of "statistical robot" in hospital statistics field[J]. journal1, 2020, 27(5): 476-480.
[6]	Tian Qi.. Work mode of medical and health statistics based on database management structure [J]. journal1, 2020, 27(3): 242-245.