BOX8 | SQL Query on Regular Expression
Question
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways
Answer ( 1 )
select count(*) from table where TIMESTAMPDIFF(minute, Time of Order, Time of Delivery )>20;
select count(*) from table where TIMESTAMPDIFF(minute, Time of Order, Time of Delivery )>30;
select count(*) from table where TIMESTAMPDIFF(minute, Time of Order, Time of Delivery )>40;
select count(*) from table where TIMESTAMPDIFF(minute, Time of Order, Time of Delivery )>50;