Exemplo de dados:
Serial ; GMP ; DataHora
"B29928";"GMP-110-008";"2012-10-01 11:13:00"
"B29928";"GMP-110-008";"2012-10-01 11:14:00"
"B2992A";"GMP-110-008";"2012-10-01 11:13:00"
"B2992A";"GMP-110-008";"2012-10-01 11:13:00"
"B2992A";"GMP-110-008";"2012-10-01 11:15:00"
"B2992B";"GMP-110-008";"2012-10-01 11:13:00"
"B2992B";"GMP-110-008";"2012-10-01 11:18:00"
"B2992B";"GMP-110-008";"2012-10-01 11:13:00"
"B2992C";"GMP-110-008";"2012-10-01 11:17:00"
"B2992C";"GMP-110-008";"2012-10-01 11:15:00"
"B2992C";"GMP-110-008";"2012-10-01 11:13:0"
Calcular Diferença de Hora Min e Max do mesmo serial
Resultado seria:
Serial ; Diferença
B29928 ; 00:01:00
B2992A ; 00:02:00
B2992B ; 00:05:00
B2992C ; 00:04:00
Agradeço se alguém poder ajudar.
Estou usando o Postgres.
Abraço.