Posts by André Carneiro • 11 points
1 post
-
1
votes1
answer174
viewsA: Select Distinct in only one of the tables
Now see if it helps you :) declare @tmp table( [ID] int, [A] int, [B] int ) insert into @tmp values (35, 30, 28) insert into @tmp values (20, 10, 4 ) insert into @tmp values (20, 10, 5 ) --…