DQL: Retrieve objects having more than one vaue

Below query to retrive objects having more than one value in repeating attribute md_keywords, A_component type extends B_component. md_keywords has been defined in B_component if i execute the query in an environment having more objects query is continuing processing not returning any thing . how to tune the query to see result SELECT r_object_id, object_name, md_keywords FROM A_component WHERE r_object_id IN (SELECT r_object_id FROM dm_dbo.B_component_r GROUP BY r_object_id HAVING count(md_keywords) > 1) and A_subtype ='profile'

Find more posts tagged with

Comments

veer1

KSMatson

Try this

select r_object_id, object_name, my_keywords 
from A_component 
where r_object_id in (select r_object_id 
from B_component
group by r_object_id having count(my_keywords) > 1) 
and A_subtype = 'profile'
enable(row_based);