Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i want to calculate
Sum of time for all operations that went ok first time it run
Operation Status Date Time
1 OK 11/12/2019 23
1 OK 11/12/2019 34
2 OK 11/13/2019 2324
3 NOK 11/14/2019 234
Should be for operation 1 = 23
Why not 34 since there is no restrict on first 3 fields not the time? What is the output for below?
Operation Status Date Time
1 OK 11/12/2019 34
1 OK 11/12/2019 23
2 OK 11/13/2019 2324
3 NOK 11/14/2019 234
Note: If you are looking row wise data of First one please clarify us?
Hi, sorry poor explanation
1 OK 11/12/2019 34
1 OK 10/12/2019 23
2 OK 11/13/2019 2324
3 NOK 11/14/2019 234
should be first OK for Number 1 + number 2 OK = 23+ 2324
So i need to select only min(Ok) for each ID and make the sum
Does it help please let me know /