Home > database >  Seek help from a great god! Own a an input too much trouble!
Seek help from a great god! Own a an input too much trouble!

Time:11-23

As shown in figure, there are two tables resulttwo and useful_warn:

Do you want to be such function:
Traverse resulttwo line, in the first act: to take the first line of the first column of data, to go to find the alarm in useful_warn orientation object ID is equal to the value of line, and then take the first line of the second column data, to go to find the alarm in the useful_warn orientation object ID is equal to the value of line, and then compare the two get in there is no such a line: the alarm location object ID is different, but the alarm types are the same, and the alarm time interval of not more than 10 min, record the number of sets of qualified, accumulation, is trying to get the final result of this group for a total of how much,
Example: this is my will resulttwo data in one line is entered the result:

Although you can try one by one slowly, because resulttwo only 276 rows of data, but there will be more afraid of later processing data, so still want a program
Thank you thank you thank!

CodePudding user response:

CodePudding user response:

CodePudding user response:


Resulttwo here, sorry on the wrong
  • Related