T-SQL Query Results Not as Expected Deduplication
- by Yoda
Hi Guys,
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.
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!