Duplicates [message #18374] |
Tue, 29 January 2002 15:22 |
Aaron
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 |
Raj
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.
|
|
|