I Need Help from SQL

Apr 8 2018 12:30 AM

I have below SQL table, I need code for the below condition

Same order ID

IF status pending to Processing it should not move more than 10 minutes return i need order id

IF status Processing to out delivery it should not move more than 20 minutes return i need order id

IF status Out delivery to out for delivery it should not move more than 30 minutes return i need order id

Please help us to give sql code

Answers (1)

try catch...............