sql语句并联去重

最新推荐文章于 2024-07-12 15:06:15 发布

【蓦然回首】

最新推荐文章于 2024-07-12 15:06:15 发布

阅读量1k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/prospertu/article/details/80480175

版权

数据库专栏收录该内容

9 篇文章 0 订阅

订阅专栏

SELECT * from ( SELECT row_number() OVER(PARTITION BY c.Qymc ORDER BY kf.updateTime) as row, c.Qymc,ko.style,ko.keyword,ko.gsid,ko.id,CONVERT(VARCHAR(100),kf.updateTime,23) as updateTime FROM
KW_Order ko
LEFT JOIN KW_Fee kf on kf.orderID=ko.id
LEFT JOIN corporation c ON c.ID=ko.gsid

where ko.KM_FirstDays>0 and kf.sucType = 1 )s where row<=4

SELECT * from ( SELECT   row_number() OVER(PARTITION  BY c.Qymc ORDER BY kf.updateTime) as row, c.Qymc,ko.style,ko.keyword,ko.gsid,ko.id,CONVERT(VARCHAR(100),kf.updateTime,23) as updateTime FROM 
 KW_Order ko 
LEFT JOIN KW_Fee kf on kf.orderID=ko.id
LEFT JOIN corporation c ON c.ID=ko.gsid
where ko.KM_FirstDays>0  and  kf.sucType = 1 )s where row<=4