T-SQL 查询结果未达到预期重复数据删除
我试图获取 Id 字段多次存在的所有记录，问题是我的查询没有返回任何内容，我不知道为什么！？这是我所知道的唯一方法。
更多信息：
- 最多有 8 个相同的订单号
- 每组按 ProcessOrder 分组，我需要其中的最低值，但仅适用于 Dupes
- 其余数据可以不同或相同。
数据包含三个 ID，全部都是骗人的：
1.客户数量
2.企业客户数量
3.订单号
这是我的代码：
select
[Customer Number],
[Corporate Customer Number],
[Order Date],
[Order Number],
[Order No],
[Order Line Status],
[Payment Method] ,
[ProcessOrder],
[Order Platform]
from Temp_ICOSOrder
group by
[Customer Number],
[Corporate Customer Number],
[Order Date],
[Order Number],
[Order No],
[Order Line Status],
[Payment Method] ,
[ProcessOrder] ,
[Order Platform]
having COUNT([Order Number]) > 1
非常感谢任何帮助！
I am attempting to get all records where and Id field exists more than once, trouble is my query is returning nothing and I have no idea as to why!? And this is the only method I know.
Some more information:
- There are up to 8 of the same Order Numbers
- Each set is grouped by ProcessOrder, I require the lowest value of these but only for Dupes
- The rest of the data can be different or the same it varies.
The data has three IDs included, all are dupes these are:
1.Customer Number
2.Corp Customer Number
3.Order Number
Here is my code:
select
[Customer Number],
[Corporate Customer Number],
[Order Date],
[Order Number],
[Order No],
[Order Line Status],
[Payment Method] ,
[ProcessOrder],
[Order Platform]
from Temp_ICOSOrder
group by
[Customer Number],
[Corporate Customer Number],
[Order Date],
[Order Number],
[Order No],
[Order Line Status],
[Payment Method] ,
[ProcessOrder] ,
[Order Platform]
having COUNT([Order Number]) > 1
Any help is much appriciated!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
从 group by 子句中删除
[Order Number]。如果按它分组，计数将始终为 1！
Remove
[Order Number]from the group by clause.If you group by it, the count will always be 1!