Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Kneeds
Starting Member
1 Post |
 Posted - 2014-01-17 : 08:54:51
|
| GOod morning, I have a query built to average turn times bases on an issue type. Here is the code:SELECT issue_type, AVG(turn_time) AS Avgturntime from(SELECT issue_type,(date_resolved-date_created) AS turn_time FROM JIRA17.FCI4JIRA_COMMON_VIEWWhere (DATE_RESOLVED BETWEEN TO_DATE('11/01/2013', 'MM/DD/YYYY') and TO_DATE('11/30/2013', 'MM/DD/YYYY')))Group by issue_typeThe resulting output works, but inside of the issue type field I have tasks and sub-tasks. I would like to combine them. For example, I will get the following:+-----------+-----------++ Issue_type+Avgturntime++ ----------+-----------++ MIS + 92.5 ++-----------+-----------++MIS Subtask+ 15.8 ++-----------+-----------+How can I have the task and sub-task combined in the output? Also this is running on PL/SQL.Any help would be appreciated as I am new to this. Thanks! |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-01-17 : 09:42:47
|
SQLTeam.com is on MS SQL Server. For Oracle questions, try dbforums.com
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
Combining results