Home » SQL & PL/SQL » SQL & PL/SQL » Duplicates
Duplicates [message #18374] Tue, 29 January 2002 15:22 Go to next message
Messages: 13
Registered: January 2002
Junior Member
OK here we go...

I have one table 2 columns...one column is client number and the other is PO number...i need duplicate PO numbers displayed by client number. Any ideas?
Re: Duplicates [message #18376 is a reply to message #18374] Tue, 29 January 2002 15:34 Go to previous message
Messages: 411
Registered: November 1998
Senior Member
select ponumber,clientnumber
from table
where ponumber in
(select ponumber
from table
group by ponumber
having count(*)>1);
Hope this will help.
Previous Topic: Counts in SQL
Next Topic: How to query records with same value in specific columns from a table
Goto Forum:

Current Time: Thu Aug 13 07:21:39 CDT 2020