How to Merge rows in Sql

Question

Hi Friends,

This is my Table,

Create Table #Temp (DueDate1 int, DueDate2 int, DueDate3 int, DueDate4 int, DueDate5 int)  
Insert into #Temp (DueDate1, DueDate2, DueDate3, DueDate4, DueDate5) Values(1,0,0,0,5)  
Insert into #Temp (DueDate1, DueDate2, DueDate3, DueDate4, DueDate5) Values(1,0,0,4,0)  
Insert into #Temp (DueDate1, DueDate2, DueDate3, DueDate4, DueDate5) Values(1,0,3,4,5)  
  
Select * From #Temp  
  

Expected result is

Answer 1

You can try this.
Select max(DueDate1),max(DueDate2) ,max(DueDate3) ,max(DueDate4) ,max(DueDate5) From #Temp