Question

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

SELECT [ID],[UserID],[Mobile],[RealName],[Email], FROM [Wuliu].[dbo].[WuliuJinbi_User]
where 1=1 And RecordStatus=1 AND NodeID=16

Answer 1

你的那个表里一个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

Answer 2

SELECT [ID],distinct [UserID],[Mobile],[RealName],[Email], FROM [Wuliu].[dbo].[WuliuJinbi_User]
where 1=1 And RecordStatus=1 AND NodeID=16
如上，在Userid 的前面添加distinct

Answer 3

SELECT [ID],[Mobile],[RealName],[Email], FROM [Wuliu].[dbo].[WuliuJinbi_User]
where 1=1 And RecordStatus=1 AND NodeID=16

追问

哥们，你这个不行，

Answer 4

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

追问

我还要显示其他数据，不只是单一的UserID