ObjectiveTo explore the application methods, advantages and disadvantages, and matters needing attention of SQL in hospital statistics and to improve work efficiency and check wrong data quickly and conveniently.Methods Through the examples of SQL in statistical monitoring of diseases, operations and disease spectrum and surgical spectrum, the application of SQL in hospital statistics was showed . Meanwhile, the advantages and disadvantages and matters needing attention were showed by inducing the differences in SQL module in eighteen key diseases and eighteen key operations.Results The use of SQL in database of medical records directly improves the efficiency of statistical work and reduces repetitive work especially in statistical monitoring. Meanwhile, SQL can be used to help check and revise original data. However, SQL is not appropriate when the statistics is more complicated such as building statistical model in hospital statistics. We should be familiar with database structure, the meaning of variables and statistical caliber because it is the premise for the application of SQL.ConclusionSQL will be a good statistical tool to help statistic monitoring and revise wrong data to improve work efficiency and because of its flexibility, it can be used as a tool to analyze data initially.
杨业春. 基于SQL的医院病种和手术统计监测应用实例分析[J]. 中国医院统计, 2019, 26(2): 111-114.
Yang Yechun. Application analysis of hospital disease and operation statistics based on SQL. journal1, 2019, 26(2): 111-114.
