question

jammed-on-mondays4sure avatar image
jammed-on-mondays4sure asked

How do I count if MRWgt is >0 and t_stamp is less than 50 seconds?

There is only one time column (t_stamp) in the table. Sometimes users will hit the button 2 times on accident. I need to find the ones to remove from the table if MRWgt column is greater than 0 and if the t_stamp is less than 50 seconds from the next t_stamp with a MRWgt > 0.

dateadddatepartdatetime-formats
count.png (14.1 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.