当前位置: 首页 > >

利用group by对数据库进行去重查询

发布时间:

select b_Name,b_Phone from dbo.ztBaoming where b_type=20
and b_ID in(select max(b_ID) from dbo.ztBaoming where b_type=20 group by b_Phone)
order by b_addtime desc

?



友情链接: