soldierdackel
Programmer
Hi there,
I've got a table PO_HEADER with a field PO_NO. Normally the PO_NO should be unique but in some cases it's not. How do I find those rows where it is not unique?
I started like this:
select distinct PO_NO
from PO_HEADER
where ..... and then I stopped!
Anyone able to help? It's an Oracle 9i database.
Cheers
I've got a table PO_HEADER with a field PO_NO. Normally the PO_NO should be unique but in some cases it's not. How do I find those rows where it is not unique?
I started like this:
select distinct PO_NO
from PO_HEADER
where ..... and then I stopped!
Anyone able to help? It's an Oracle 9i database.
Cheers