sql语句并联去重

最新推荐文章于 2024-10-08 14:10:00 发布

【蓦然回首】

最新推荐文章于 2024-10-08 14:10:00 发布

阅读量1k

点赞数

分类专栏：数据库

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

版权

数据库专栏收录该内容

9 篇文章 0 订阅

订阅专栏

本文详细介绍了使用SQL进行复杂查询的方法，包括如何通过左连接获取多个表中的数据，并结合分区和排序来筛选特定条件下的记录。通过对实际案例的解析，读者可以了解到如何构造高效的SQL语句来提高数据处理效率。

摘要由CSDN通过智能技术生成

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