Grouping by name and to incorporate the data of time difference value is not more than five seconds for a (format as yyyy - hh: mm - dd 24 mm: ss)

CodePudding user response:

Specifically, not even any example,,,

CodePudding user response:

I have a creattime table inside field, there is also a carno fields, save the data to record the carno vehicles speeding, eventually want to get the current carno overtaking number, if the current time (continuous 3 seconds) is continuous, it is a number of the current speed,

CodePudding user response:

You ask questions like this are difficult to get help

1. Post table structure
2. The given sample data
3. The expected results

CodePudding user response:

The data looks like, and what result, all the way,

CodePudding user response:

table structure is this

CodePudding user response:

this is the desired result

CodePudding user response:

LOCATION_DATE time continuous in the table is considered as a speeding (defaults to 5 seconds will locate a) if the interruption is no, speeding the length for the page spread, eventually overtaking number of statistics

CodePudding user response:

http://www.itpub.net/thread-1348543-1-1.html