sql语句并联去重

最新推荐文章于 2025-01-12 07:30:00 发布

原创最新推荐文章于 2025-01-12 07:30:00 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

9 篇文章

订阅专栏

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

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