In hospital statistics, due to the difference of data query language, the hospital statistical results are often quite different from the actual data. Therefore, the application of SQL in hospital statistics is proposed. Use java + spark SQL to read the data information to be counted in the hospital, and have an in-depth understanding of common basic tables and fields, so as to facilitate the smooth completion of subsequent statistical work. Using structured query language, the statistical indicators such as postoperative complications, disease ranking and workload of the surgeon are written into SQL statements, and finally the SQL statement integration results are presented in the form of tables. The experimental results show that compared with the two statistical methods proposed in the literature, the statistical error is reduced by 30.25% and 35.61%.

Xu Lixiang. Application of SQL in hospital statistics. Frontiers in Medical Science Research (2021) Vol. 3 Issue 4: 30-33. https://doi.org/10.25236/FMSR.2021.030406.

[1] CHEN Wenjing. Application of digital management in hospital statistics [J]. Management informatization in China, 2018, 21(06):160-161.

[2] WEI Wenyu. Application analysis of hospital management and statistical information of traditional Chinese medicine hospitals [J]. Continuing medical education in China,2020,12(35):103-105.

[3] CHU Zijun. Analysis of hospital statistical work mode in the era of big data [J]. Medical information, 2020,33(21):24-25.

[4] LAI Fuhu, ZHANG Zheng, XU Qingshi, et al. Application of "statistical robot" in the field of hospital statistics [J]. Hospital statistics in China, 2020, 27(05):476-480.