Stack Overflow en español Asked by David Gil on January 26, 2021
Tengo la siguiente query:
SELECT r_request.request_id, MAX(request_workflow_history_date - r_request.request_creation_date) as
time
FROM r_request
JOIN r_request_workflow_history
ON r_request.request_id = r_request_workflow_history.request_id
WHERE r_request.request_status = 'A'
AND request_code = 'RQENTITY'
group by r_request.request_id
la cual me devuelve el siguiente resultado:
421871798754215263 "16:04:45.825"
448642339783574730 "19:15:32.636"
448657631821694166 "18:19:11.326"
Necesito calcular el valor promedio de esas 3 fechas y no sé cómo hacerlo.
Gracias de antemano.
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP