I have doubt in sql server
source: emp
id | name | check
100 | a | 1
100 | b | 2
100 | c | 3
100 | d | 5
101 | a | 1
101 | b | 5
102 | a | 1
102 | b | 2
here same id have check 2 and 5 values then we need to replace check values to 2 check values for that id.
based on above table I want load/output data into target table like below
target : emp1
id | name | check
100 | a | 1
100 | d | 2
100 | c | 3
101 | a | 1
101 | b | 5
102 | a | 1
102 | b | 2
please tell me query how to achive this task in sql server