SELECT * FROM(
select *,ROW_NUMBER()OVER(PARTITION BY Cust_Id ORDER BY Trace_Date DESC)RN FROM dbo.t_custtrace with (nolock)
where cust_id in ('K0307111050COX','K14070700108','K14070700103')
)T
WHERE RN<=3
select *,ROW_NUMBER()OVER(PARTITION BY Cust_Id ORDER BY Trace_Date DESC)RN FROM dbo.t_custtrace with (nolock)
where cust_id in ('K0307111050COX','K14070700108','K14070700103')
)T
WHERE RN<=3
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货