怎样去掉重复的数据,id是重复的 例如,UId FieldName1 Name1 Age1 sex2 Name2 Age2 Sex2 Habbit怎样得到count=2也就是重复的id只取一条数据。。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from tb a where not exists(select 1 from tb where UId=a.UId and FieldName>a.FieldName) [with t as(select uid,fieldname,row_number() over(partition by uid order by uid) rnfrom tb)select * from tb where rn=1 select *from tb twhere FieldName=(select max(FieldName) from tb where uid=t.uid) select fieldName from tb group by fieldname select uid , min(FieldName) FieldName from tb group by uidselect uid , max(FieldName) FieldName from tb group by uid 兩個字段都重復?select UId,FieldName from Table group by UId,FieldName select uid , min(FieldName) FieldName from tb group by uid,select uid , max(FieldName) FieldName from tb group by uid 都可以 SQL 排序 问一个奇怪的问题:有两块网卡的服务器上装有SQL SERVER,那么这个数据库到底“属于”哪个网卡呢? 请问有没有类似与all is 的这样的语句啊?谢谢 sql 错误?急呀 请教一个存储过程问题 SQL 2000 互联网 异地 备份 此视图如何实现? 大力,求救 如何得到机器中 SQl SERVER GROUP 中所有的数据库服务器名及本地数据库服务器名? 问个关系问题 往SQL server 里面循环插入数据 多表联合查询 做统计报表 效率
select * from tb a where not exists(
select 1 from tb where UId=a.UId and FieldName>a.FieldName
)
with t as(
select uid,fieldname,row_number() over(partition by uid order by uid) rn
from tb
)
select * from tb where rn=1
*
from
tb t
where
FieldName=(select max(FieldName) from tb where uid=t.uid)
select uid , min(FieldName) FieldName from tb group by uid
select uid , max(FieldName) FieldName from tb group by uid
兩個字段都重復?
select UId,FieldName from Table group by UId,FieldName
,
select uid , max(FieldName) FieldName from tb group by uid 都可以