The 2020-03-28 28 _nw_car2 26
The 2020-03-28 28 _nw_car9 26
The 2020-03-28 28 _nw_car10 25
The 2020-03-28 28 _nw_car6 25
The 2020-03-28 28 _nw_car5 25
The 2020-03-28 28 _nw_car3 25
The 2020-03-28 28 _nw_car1 26
The 2020-03-28 28 _nw_car4 25
The 2020-03-29 28 _nw_car5 26
The 2020-03-29 28 _nw_car3 26
The 2020-03-29 28 _nw_car1 26
The 2020-03-29 28 _nw_car4 26
The 2020-03-29 28 _nw_car2 26
The 2020-03-29 28 _nw_car9 4
28 _nw_car10 24 2020-03-29

CodePudding user response:

Select * from sometable where date='2020-3-29' and somefield=28 _nw_car9 and judging abnormal conditions

CodePudding user response:

I don't know this data have abnormal situation, find out the abnormal data,,,, is this meaning

CodePudding user response:

You don't know what is abnormal standard?
Know the judgment conditions on it

CodePudding user response:

How to say, is usually the number of a few cars won't vary too big, to judge the day the number of occurrences of a car and other car vary widely, this is the general idea