Topic: How to add a line
Children, prompt please a command which at me would add under the project.
My request produces the table as on a picture, and it is necessary that it still produced a total sum (for example also 187+155,5 and 129+36,5 etc.)
select case row_number () over (partition by dd.projectcode order by dd.holeID) when 1 then dd. PROJECTCODE end as x_project; sum (cast ((case when name = ' totaldrilldepth ' then value end) as float)) s from drillingdetail dd where dd.holeid in (select holeid from DRILLINGDETAIL where cast ([DRILLINGDATE] as date) between ' 13-feb-2017 ' and ' 20-feb-2017' ) and cast ([DRILLINGDATE] as date) between ' 13-feb-2017 ' and ' 20-feb-2017' group by PROJECTCODE, HOLEID
It seems at me curve hands...