sql query problem

hi all,

i posted this to the programming forum but only got 12 views, so hoping someone in here might be able to help me


using oracle, im trying to find records that have more than 1 corresponding record in the same table if that makes any sense at all..

a query such as:

select field1, count(field2) from table where count(field2) > 1 group by field1

it should be a 1:1 relationship between field1 and field2 but theres reason to believe field2's are not unique..

Thanks in advance

 

 

 

 

Top