Shulou(Shulou.com)05/31 Report--

It is believed that many inexperienced people are at a loss about how to realize the statistical business in a certain period of time in SQL. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

There is an error on the report, and only the fields related to this article are listed as follows: escalator (ReportPerson), escalation error ID (ErrorID), escalation time (ReportTime), status (State), with median values of 0 (unresolved), 1 (processed) and 2 (resolved). What we need to do now is to count the total number of errors reported by each whistleblower and the total number of resolved errors within a certain period of time [beginTime,endTime] (where beginTime,endTime is passed in from the foreground). The code for the copy is as follows: select a.ReportPersonrea.sumOfErrorauthorreb. UploedError from (select COUNT (ErrorID) as sumOfError,ReportPerson from PCR_ConstructInfo where (ReportTime > beginTime) and (ReportTimebeginTime) and (ReportTime)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.