Abstract
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%.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
