Challenge: SQL check next record against previous -
I have some data that needs to be confirmed, and when I get a quick formula working in Excel then I Some of the SQL can be found that can do the same, so I can use it as a check in my database. The data is only: ACACIA ST (KLN) | 1073 | 1149 | Failed! | 76 ACASIA ST (KLN) | 1073 | 1151 | Failed! | 78 ACACIA ST (KLN) | 1150 | 1332 | Failed! | 182 ACASIA ST (KLN) | 1151 | 1332 | Failed! | 181 ACASIA ST (KLN) | 1606 | 2079 | | 473 Activity ST (WRK) | 6 | 215 | win! | 20 9 Activity ST (WRK) | 215 | 227 | win! | 12 Activity ST (WRK) | 227 | 423 | win! | 196 Activity ST (WRK). 423 | 54 9 win! | 126 Activity ST (WRK). 54 9 600 | | 51 Adrian CT (WMN) | 5 | 107 | win! | 102 Adrian CT (WMN). 107 | 122 | | 15 Aerodrome RD (LYB). 0 | 140 | win! | 140 Aerodrome RD (LYB) | 140 | 428 | win! | 288 Eroderome RD (LYB) | 428 | 716 | win! | 288 Eroderome RD (LYB) | 716 | 998 | win! | 282 Eroderome RD (LYB) | 998 | 1280 | win! | 282 Eroderome RD (LYB) | 1280 | 1566 | win! | 286 Aerodrome RD (LYB) ...