select * from
(select * , row_number() over(partition by ii order by ShuiKong.sid) r from ShuiKong ) as mytab
where r=1
sql查询:某列中含两条相同数据,只取一条
最新推荐文章于 2024-07-04 16:29:03 发布
select * from
(select * , row_number() over(partition by ii order by ShuiKong.sid) r from ShuiKong ) as mytab
where r=1