Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL-question (two fields in one)
If you want to check the primary key fields you can use the following SQL statment. (Of course there are more solutions)
select field1,field2,count(*)
from tablename
group by field1,field2
having count(*) > 1
Maikel Received on Mon Jun 16 1997 - 00:00:00 CDT