How fast in SQL select the 2020-03-29 day 28 _nw_car9 outliers (data) there are more than 20 days mo-CodePudding

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:

This is the three fields, or a field?
Three fields: where A='2020-03-29' and B like '28 - nw - car %' and C> 20