Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The table below, I need to find and add up the difference.
Placa = 'LSP1241',Type(Chegado) ('11/01/2019 13:58:44', 'DD/MM/YYYY hh:mm:ss') - Placa = 'LSP1241',Type(Saindo) ('11/01/2019 14:32:53' ,'DD/MM/YYYY hh:mm:ss')
How would this set analysis
Placa | Date | Type |
LSP1241 | 11/01/2019 13:58:44 | Chegando |
LSP1241 | 11/01/2019 14:32:53 | Saindo |
LVO7376 | 11/01/2019 15:26:28 | Chegando |
LVO7376 | 11/01/2019 15:51:20 | Saindo |
NHV8442 | 11/01/2019 12:31:31 | Chegando |
NHV8442 | 11/01/2019 13:44:56 | Saindo |
NIC6747 | 11/01/2019 10:20:43 | Chegando |
NIC6747 | 11/01/2019 10:27:35 | Saindo |