How to alter the below table?

Question

I have a table like Below

**ID Value1  Value2**

 11 AAAA    ZZZZ

 11 A134    ZZZZ

 12 BBBB    YYYY

 12 B222    YYYY

 13 CCCC    XXXX

 13 A134    XXXX

And I need the result as Below

ID Value1 Value2

11  AAAA    ZZZZ

12  BBBB    YYYY

13  CCCC    XXXX

Please help me on this.

Answer 1

;with cte as
(
select id,value1,value2,row_number() over(partition by id order by id) as rn from #t
)

select id,value1,value2 from cte where rn=1

See Demo