Hi its good seeing that logic, but i have scenario

c1 c2 c3

1 a a1

1 a b1

1 a c1

2 b a7

2 b b4

3 c d4

3 c b5

3 c v5

4 d u7

in this data provided , i would like to pick up the first set of values

ex: 1 a a1

2 b a7

3 c d4

4 d u7

should be the out put( in sql server)