select id,name,age from( select px=row_number()over(partition by NAME order by(select 1)),* from tbl )a where px=1
SELECT * FROM [Users] WHERE [Id] IN(SELECT MAX([Id]) FROM [Users] GROUP BY [Name])
SELECT * FROM [Users] WHERE [Id] IN(SELECT MAX([Id]) FROM [Users] GROUP BY [Name]) SELECT * FROM [Users] WHERE [Id] IN(SELECT Min([Id]) FROM [Users] GROUP BY [Name])----以上所有版本通用 select id,name,age from( select px=row_number()over(partition by NAME order by(select 1)),* from tbl )a where px=1 ---row_number() 只有 2005 版本以上支持
select id,name,age from(
select px=row_number()over(partition by NAME order by(select 1)),* from tbl
)a
where px=1
WHERE [Id] IN(SELECT MAX([Id]) FROM [Users] GROUP BY [Name])
WHERE [Id] IN(SELECT MAX([Id]) FROM [Users] GROUP BY [Name])
SELECT * FROM [Users]
WHERE [Id] IN(SELECT Min([Id]) FROM [Users] GROUP BY [Name])----以上所有版本通用
select id,name,age from(
select px=row_number()over(partition by NAME order by(select 1)),* from tbl
)a
where px=1
---row_number() 只有 2005 版本以上支持
如果Id不唯一,用left join如何查?能请教下吗?