Question

在线跪求答案，下面一条sql，过滤Userid，显示结果为一个Userid只有一条数据。

SELECT [ID],[RecordStatus],[CreateTime],[CreateUser],[UpdateTime],[UpdateUser]，[NodeID],[UserID],[Mobile],[RealName],[Email],[ProvinceID],[CityID],[AreaID],[Address],[Birthday],[Gender]
FROM [Wuliu].[dbo].[WuliuJinbi_User]
where 1=1 And RecordStatus=1 AND NodeID=16

Answer 1

SELECT [UserID] FROM [Wuliu].[dbo].[WuliuJinbi_User]
where 1=1 And RecordStatus=1 AND NodeID=16
group by [UserID]

这个ok

Answer 2

能不能把数据贴出来看看

Answer 3

SELECT [UserID] FROM [Wuliu].[dbo].[WuliuJinbi_User]
where 1=1 And RecordStatus=1 AND NodeID=16
group by [UserID]

Answer 4

你的那个表里一个userid对应多条数据吗？

我根据userid分组排序，然后取的每组第一条数据
SELECT [ID],[RecordStatus],[CreateTime],[CreateUser],[UpdateTime],[UpdateUser],[NodeID],[UserID],[Mobile],[RealName],[Email],[ProvinceID],[CityID],[AreaID],[Address],[Birthday],[Gender]
FROM(
SELECT [ID],[RecordStatus],[CreateTime],[CreateUser],[UpdateTime],[UpdateUser],[NodeID],[UserID],[Mobile],[RealName],[Email],[ProvinceID],[CityID],[AreaID],[Address],[Birthday],[Gender]
ROW_NUMBER() OVER(PARTITION BY UserID ORDER BY UserID) "ROW" FROM [Wuliu].[dbo].[WuliuJinbi_User]
where 1=1 And RecordStatus=1 AND NodeID=16 )
WHERE "ROW" < 2