How to extract duplicate orders from DB

Question

Using SQL Server 2014. Taking the following recordset:

I need to find a way to extract the ordOrderNum which is duplicates, with a different DeliveryNum. In this example, orders 93400460 and 93400467 would be extract, because they are duplicates. Order 93408170 is ok. How can I do that??!

thanks for your time and help

Please read [this](https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/) for some tips on improving your question. — HABO, Dec 16 '20 at 19:19

score 1 · Accepted Answer · answered Dec 16 '20 at 19:06

1

You can use group by and having:

select ordOrderNum 
from mytable
group by ordOrderNum
having min(ordDeliveryNum) <> max(ordDeliveryNum)

answered Dec 16 '20 at 19:06

GMB

216,147
25
84
135

Thiyagu · Answer 2 · 2020-12-16T19:02:32.227

0

Try this:

SELECT 
ORDORDERNUM, ORDLINENUM, 
COUNT(*) FROM TABLE
GROUP BY 
ORDORDERNUM, ORDLINENUM
Having count(*)>1

edited Dec 16 '20 at 19:02

answered Dec 16 '20 at 18:46

Thiyagu

1,260
1
5
14

thanks for the answer but it doesn't work. It returns nothing – Dominic Dec 16 '20 at 18:59
I think you meant to use ordDeliveryNum and not ordLineNum. Making that change will return the correct results – JMabee Dec 16 '20 at 19:43

How to extract duplicate orders from DB

2 Answers2