equal insread of distinct
Posted
by MirooEgypt
on Stack Overflow
See other posts from Stack Overflow
or by MirooEgypt
Published on 2010-05-10T15:29:21Z
Indexed on
2010/05/10
15:34 UTC
Read the original article
Hit count: 111
Filed under:
sql-server-2005
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
© Stack Overflow or respective owner
