Link to home
Start Free TrialLog in
Avatar of Allen Pitts
Allen PittsFlag for United States of America

asked on

Component is listed with a Protocol more than once

The table Protocol_Component has fields:

PROTOCOL_COMPONENT_ID
PROTOCOL_ID
IS_DISABLED
COMPONENT_ID
OWNER_ID
OWNER_TYPE_CODE

Need to develop a list of Protocols and Components
where a Component is listed with a Protocol more than once.

Thanks.

Allen in Dallas
Avatar of Sean Stuber
Sean Stuber

select protocol_id, component_id, count(*)
from your_table
group by protocol_id,component_id
having count(*) > 1
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Allen Pitts

ASKER

Thanks