select *,case when 状态=0 then '未读' when 状态=1 then '已读' end as ZT,case when 发票类型=1 then '普票' when 发票类型=4 then '专票' end as PP from
(select no=row_number() over(partition by 单据编号 order by getdate()),* from 金税接口视图) t,(select 单据编号,count(*) as 行号 from dbo.金税接口视图 group by 单据编号 having count(*) >= 1) S
where t.单据编号=s.单据编号 and no=1
sql 去除重复显示一条并显示行数
最新推荐文章于 2022-07-29 17:49:56 发布