Another SQL help

[soldierdackel]

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

 

[soldierdackel]

Don't bother to reply. I found a solution:

select distinct po_no
from po_header
group by po_no
having count(po_no) > 1

Cheers

 

[r937]

you don't need the DISTINCT

groups are distinct by definition

rudy

http://r937.com/

SQL Consulting