Remove duplicate recoed with exclude one column

Question

Hello friends,

 

I have a query like:

select '1101' as Id, 'prd1' as Name, '1' as DisplayOrder
union ALL
select '1102' as Id, 'prd2' as Name,'2' as DisplayOrder
union ALL
select '1103' as Id, 'prd3' as Name, '3' as DisplayOrder
union ALL
select '1102' as Id, 'prd2' as Name, '4' as DisplayOrder

 And it's output:

 

 

But I want output like: 

 

 or

 

 

What should I do?
How can I get above output using SQL query or from c# code?

Thanks.