如何过滤数据库重复字段

[干爹]

如题:
SELECT b.zpzw,a.pname,a.qyname, a.qyfrom
FROM Company_Basemeans AS a LEFT OUTER JOIN invite_info AS b
ON a.qyname = b.qyname2
where (b.zpzw like'%文案%' or a.qyname like'%传媒%')
order by b.uptime

现在输出时a.qyname会有重复的记录
我想只要其中的一条怎么处理好呢
这样写distinct(a.qyname)是无效的,杯具

[xman_78tom]

;with t as (
SELECT b.zpzw,a.pname,a.qyname, a.qyfrom,b.uptime,
row_number() over (partiton by a.qyname order by b.zpzw) rn
FROM Company_Basemeans AS a LEFT OUTER JOIN invite_info AS b  
ON a.qyname = b.qyname2
where b.zpzw like'%文案%' or a.qyname like'%传媒%'
)
select zpzw,pname,qyname,qyform 
from t
where rn=1
order by uptime;

[干爹]

在线等哟,怎么没人说话了

[cuitianfei_521]

with t as
(
select a.qyname from
(
SELECT b.zpzw,a.pname,a.qyname, a.qyfrom
FROM Company_Basemeans AS a LEFT OUTER JOIN invite_info AS b
ON a.qyname = b.qyname2
where (b.zpzw like'%文案%' or a.qyname like'%传媒%')
order by b.uptime
) a
)
select distinct qyname from t

[干爹]

OK了,谢谢大家哈