Kumaran P

Kumaran P

  • NA
  • 102
  • 10.7k

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)