equal insread of distinct
- by MirooEgypt
SELECT DISTINCT IncreasmentAmount, Name, regionid
FROM Pricing.GroupOfRegions
where regionid in (6,7)
i have this result
12.80 AB 6
13.00 ABC 6
15.00 AC 6
12.80 AB 7
13.00 ABC 7
i wanna add more condition where IncreasmentAmount are equals which means i got the rows where regionid in (6,7) and have the same IncreasmentAmount so i got finally
12.80 AB 6
12.80 AB 7
