Application of SQL in hospital statistics

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