Aggregating data in a single select statement without join and pivot

Viewed 45

I have a table Input_Table defined like below

create table Input_Table(id int, [year] varchar(100),initial int,final int)

   insert into Input_table values(1,'2017',1,11)
   insert into Input_table values(2,'2017',8,11)
   insert into Input_table values(3,'2017',3,33)
   insert into Input_table values(4,'2016',6,44)
   insert into Input_table values(5,'2016',6,44)
   insert into Input_table values(6,'2017',6,44)
   insert into Input_table values(7,'2016',4,8)
   insert into Input_table values(8,'2017',2,8)

I need to get the output based on the requirement shown in the pic without using pivot or JOINsenter image description here

3 Answers
Related