Hello. I am trying to create a query that will provide a report containing the run times broken down into seconds, minutes, etc. So far, I have the following query, but I keep receiving an error. Can you help me with this? Thanks!
SELECT rn_test_id, sum(rn_duration) as sec, sum(rn_duration) / 60 as min, sum(rn_duration) / 3600 as hr
where CYCLE.CY_FOLDER_ID /*Test Set.Test Set Folder*/ like ‘Loan & Account Servicing_18_Q2’
group by rn_test_id
Marked as spam
Please log in to participate..