22,209
社区成员
发帖
与我相关
我的任务
分享
select ID,NAME, other,max(VALUE) as value
from tb
group by ID,NAME
order by ID,NAME
执行肯定不成功
1、在order后加other
2、在other上加聚集函数
select * from TB as a where not exists(select 1 from TB where ID=a.ID and Name=a.Name and Value>a.Value)
select ID,NAME,max(VALUE) as value
from #tb
group by ID,NAME
order by ID,NAME
select ID,NAME, other,max(VALUE) as value
from tb
group by ID,NAME
order by ID,NAME
select ID,NAME, other,[VALUE] as [value]
from tb T WHERE [VALUE]=(SELECT MAX([VALUE]) FROM TB WHERE
ID=T.ID AND NAME=T.NAME)