Sql查询问题

[豆-芽-菜]

图示1、是我要查询的表数据，图2、是我查询的结果！问题是我要根据UserID查询具有相同的Key+Value值的结果、查询SQL如下：
Select distinct PropertyName,Value From bimproperties _outer
Where UserId IN (2,3,4) And
(Select COUNT(1) From bimproperties Where UserId IN (2,3,4) and PropertyName+Value=_outer.PropertyName+_outer.Value)=3 And Value<>''

现在的问题是用这种Sql查询，耗时太久，想换一种查询方式，不知道如何写Sql、还请各位大师帮帮忙！谢谢！

[smartisanT1]

引用 1 楼 kk185800961 的回复:

--是要这样？
SELECT PropertyName, Value
FROM bimproperties
GROUP BY PropertyName, Value
WHERE UserId IN(2,3, 4) AND Value<>''
HAVING COUNT(*)=3

HAVING COUNT(*)=3 这句代码目的是？？？

[薛定谔的DBA]

引用 1 楼 kk185800961 的回复:

--是要这样？
SELECT PropertyName, Value
FROM bimproperties
GROUP BY PropertyName, Value
WHERE UserId IN(2,3, 4) AND Value<>''
HAVING COUNT(*)=3

筛选条件，PropertyName, Value 有3个相同的值则取出 PropertyName, Value

[薛定谔的DBA]

--是要这样？
SELECT PropertyName, Value
FROM bimproperties
GROUP BY PropertyName, Value
WHERE UserId IN(2,3, 4) AND Value<>''
HAVING COUNT(*)=3

[豆-芽-菜]

引用 2 楼 smartisanT1 的回复:

[quote=引用 1 楼 kk185800961 的回复:]

--是要这样？
SELECT PropertyName, Value
FROM bimproperties
GROUP BY PropertyName, Value
WHERE UserId IN(2,3, 4) AND Value<>''
HAVING COUNT(*)=3

HAVING COUNT(*)=3 这句代码目的是？？？[/quote]等于3是因为我那个UserID对应的in（2,3,4）这里面的值的个数是3