SELECT 
	DISTINCT O2.*
FROM 
	tmpOrders AS O1
INNER JOIN
	tmpOrders AS O2
	ON O1.RecordID <> O2.RecordID
	AND O1.ProductID = O2.ProductID
	AND O1.OrderDate = O2.OrderDate
	AND O1.ProductClass = O2.ProductClass
	AND O1.ProductType = O2.ProductType
LEFT OUTER JOIN
	tmpEvalRecs AS Rec
	ON O2.RecordID = Rec.RecordID
WHERE
	Rec.RecordID IS NULL

select COUNT(tmpOrders.productid) as duplicates,tmpOrders.productid,tmpOrders.productclass,tmpOrders.OrderDate,tmpOrders.ProductType
from tmpOrders 
group by tmpOrders.productid,tmpOrders.productclass,tmpOrders.OrderDate,tmpOrders.ProductType
having COUNT(tmpOrders.productid)>1

with CTE
as
(
select *, ROW_NUMBER() over (PARTITION by productid,productclass,producttype,orderdate order by orderdate) as rn
from tmpOrders
)
select * from CTE where rn>1;