Home > database >  SQL statements to solve ~
SQL statements to solve ~

Time:09-29

Want to ask the date of time lag and ~
As shown in assignedbyperson364 minus the assignedbyperson228 time together and with a total time

Assignedbyperson fields below 228 and 364 must be adjacent so only two time of figure, but a few set of effective hope statements can be judged

CodePudding user response:

CodePudding user response:

The image data in the post directly, don't post pictures,
General logic don't know can you understand no,
1. According to the time sequence to get a first serial number rn
2. Screening assignedbyperson data for 364 or 228,
3. Since the connection, the connection conditions for the first table rn is equal to the second table rn 1 value, the first table assignedbyperson=288, the second table assignedbyperson=364
  • Related