Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme 

Using Window Functions to zero out sales orders?

Language: Editor: Layout:
View schema
Execution time: 0,02 sec, rows selected: 4, rows affected: 8, absolute service time: 0,17 sec 
edit mode |  history
   id field_id field_number field_date field_inserted field_sale
1 5 1 100 2017-03-12 2017-03-11 01:06:00 Buy
2 6 1 100 2017-03-12 2017-03-11 01:07:00 Buy
3 7 1 110 2017-03-11 2017-03-11 01:03:00 Buy
4 8 2 100 2017-03-11 2017-03-11 01:03:00 Buy