22,209
社区成员
发帖
与我相关
我的任务
分享
--在user_mstr表中查询和id为001的name,sex,age相同的所有数据
SELECT a.* FROM user_mstr a
INNER JOIN (
SELECT * FROM user_mstr
WHERE id='001'
) b ON a.name=b.name AND a.sex=b.sex AND a.age=b.age
DECLARE @id INT
SET @id=1
SELECT * FROM t AS a WHERE EXISTS(
SELECT 1 FROM t AS b
WHERE b.id=@id AND a.name=b.name AND a.sex=b.sex AND a.age=b.age
)